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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-04 : 08:03:53
|
| Michael writes "I have an Excel spreadsheet that I am trying to import into a SQL table. The import runs smoothly without errors however, entire columns of data are missing after the import. The problem occurs on columns where there is no data in the first 20 rows. For instance, I have a column called "actionRequired". This column is generally blank unless action is required for one of the records (rows). The first time data appears in this column is on row 25. When I run the import, no data is imported for the entire column. If I put a value in row 1 of that column, then data is imported correctly for all rows in that column.It is as if SQL server is scanning the first 20 rows and if it doesn't find anything, then it ignores the column altogether. This appens on multiple columns where data does not appear in the first 20 rows. Is this a bug??? Is there a workaround other than putting bogus data in all columns of the first row?This particular spreadsheet has 4000 rows and about 200 columns. Thanks for your assistance.Michael" |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-10-04 : 16:08:44
|
| Yes I have replicated the same issue.I hope we may solve this issue, first column should be unique or some data then we may solve. This is not 100% solution. But .....With RegardsBSR |
 |
|
|
leslieb
Starting Member
23 Posts |
Posted - 2008-08-26 : 22:16:49
|
| I am having the same problem. Is there a solution found for SQL 2005? |
|
|
|
|
|
|
Missing data when importing from Excel