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 |
|
galorfindel
Starting Member
1 Post |
 Posted - 2005-07-08 : 17:52:03
|
| I am attempting to import data from an excel 2000 spreadsheet into a ms sql server table. The problem is that the spreadsheet has over 5k rows of data but after the dts is performed it has only copied the first 50 or so rows into the table. To perform the dts I am right clicking on my table which is empty and selecting all tasks > import data then I choose the "Microsoft Excel 97-200" option from the drop down for data source then I select the excel spreadsheet from the desktop click next and select my db and table click next leave copy tables checked click next I see two options in the "select source tables and views" one is the name of the table and the other is the name of the table with a $ after it. I check the one without the dollar sign and then select my destination table leave other settings at default and click next run immediately. When its done I look in the table and all the column mappings and data seem to be correct except that it has only copied over the first 50 rows from the spreadsheet - Why does it not copy over all 5k of the rows?Any help is GREATLY appreciated at this point.THANKS,Charlie |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Help- Help! with excel import