Excel Data To SQL Server
It is very easy to get Excel data into SQL Server database tables.
1. Select the data in Excel you want to move into SQL Server.
2. On the Right Click menu select ‘QC – SQL Inserts’.
3. Modify the Generator SQL to customize the Insert Statements generated.
3. Copy the Insert Statements into the SQL editor and click ‘Run SQL’.
And you’re done, your Excel data is now in your SQL Server table.
After You’ve Moved Your Excel Data Into SQL Server
QueryCell will tell you how many rows were inserted but you can of course query the SQL Server database yourself, from within Excel (using QueryCell) to check.