I'm baffled by an import issue I have. I'm using the import/export wizard in SSMS for SQL server 2008. I'm import into a database table for an excel file. The file contains 39 columns. When I use the wizard to import the data only 36 columns are being imported. Can you help me determine why? I can't think of what may be the reason the other 3 columns are not imported.
Try saving the file to csv format and then using a hex editor to determine if there's a weird character between columns 36-39 that would cause it to think it's at the EOL. Pretty sure you have to go to text format for that and not directly from Excel format.
Thanks for your response. I had to leave work that afternoon and didn't see your response until today when I returned. I'm not certain what a hex editor is. Also when I put the file in csv format, fewer columns are imported. actually below 10 are imported.