Monday, March 12, 2012

How to import Excel files

I have data in excel files I want to import it to existing SQL Server database. I can use SQL Server built in import tool but before Importing, the data needs to be validated. What is the best way to do this?
Thanksimport it into a temp table, validate it, import to main table.

No comments:

Post a Comment