Importing large sets of Excel 2000 data to SQL database
I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 16, 2010 8:08 PM
UPDATED:
August 18, 2010 6:51 PM
Answer Wiki:
When you open the SQL Server Management Studio (SQL Server 2005+) or Enterprise Manager (SQL 2000 and older) you can use the import/export wizard to import data. Right click on the database you want to import the data into and select all tasks, then select the import data option. The wizard will allow you to import data from each Excel sheet into the database. It will create the table to put the data into for you, or you can create the table ahead of time.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
