September 29, 2003 at 2:17 am
When I import from Excel into SQL Server 2000 using the DTS designer, if the few n rows of a column have NULL then the whole column is considered to be NULL even if there is data further down. Is there a way around this?
September 29, 2003 at 5:34 am
The DTS wizard only examines the first eight rows of the spreadsheet, so if none of those rows have a value in a column, it's very possible for the wizard to "guess" wrong. If you cannot arrange for data to be in all columns within the first eight rows, a workaround is to save the sheet as text and then import the text file using DTS, where you control the parsing and data type choices.
--Jonathan
Edited by - jonathan on 09/29/2003 05:34:17 AM
Edited by - jonathan on 09/29/2003 05:34:47 AM
--Jonathan
October 3, 2003 at 4:44 am
Also you can try adjusting the transofrmation yourself to make sure it is seeing it. Or make sure the first row has column names.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply