Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jubilanttiger
Starting Member
19 Posts |
 Posted - 2005-10-31 : 09:31:44
|
| Is there a tool or code which I can use to import multiple Excel 2000 Spreadsheets data into SQL Server 2000 tables.Earlier I had been using EM data import feature to import the data one excel spreadsheet at a time. But now am at a point where there are plenty of Excel spreadsheets (to import) and therefore I need to automate the process of importing all the excel spreadhsheets into the database in one shot.Do you have any suggestions?Thanks. |
|
|
juvethski
Starting Member
46 Posts |
|
|
jubilanttiger
Starting Member
19 Posts |
Posted - 2005-11-03 : 16:45:06
|
| Thanks a lot for your reply !!! the link was helpful. |
 |
|
|
|
|
|
Import from Excel 2000 to SQL Server 2000