September 13, 2005 at 3:59 am
i have an excel sheet [sheet1$] . it has some records. all cells are in text format.
i imported this excel sheet[sheet1$] to the SQL server database. in SQL server DB i opened table sheet$(created by default) i found some fields NULL!! ...what happened to import ? it could not import correctly !
September 13, 2005 at 8:35 am
When you import, SQL looks at the first 8 rows to determine the datatype, no matter how you have the cell formatted in Excel. If it finds letters 'abcdef' and then in row 9 there is '123' it will make that cell NULL in the upload. VERY annoying.
When you do the import, click on the Transform button and verify that all the fields will be created as varchar. You might also copy all the data from your excel spreadsheet to a new one just in case there is some bad formatting on this one.
Hope this helps,
Michelle
September 14, 2005 at 2:41 pm
If that does not work you may try importing to Access first. It will list import errors in a table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply