One of the methods is explained in the article Excel VBA Save File Dialog, The default title. Note: Make sure the Excel sheet has the same structure as the SQL table in the database. How to use SaveAs command in Excel through VBA February 15. This step make sure you are select the checkbox of run immediately and click nextĬlick Finish to finish the wizard and wait until the wizard completed successfully. In project properties, Debug-> Select start external program -> Type the full path to access and add the excel file full path as argument. In VS, goto Tools->Attach To Process-> Find Excel.exe and double click.

Select the source table from Excel and destination table from your database and click next In the launched Excel, open your excel file and start debugging. Select Data source as Microsoft Excel and specify the path of the Excel file.Ĭhoose the Destination as SQL Server then select the database.Ĭlick Next to specify the table copy or query Right-click on the database that contains your tables and clicks on > Tasks > Import Data. The simple way to import data from an Excel file to a specific SQL table in the SQL Server database is using Import Wizard Import data from Excel to a table in SQL Server

How to debug excel file