This is a weird problem. Attached is an excel spreadsheet that when you use the default import process is Access 2010, it produces an error file which states truncated record. Within the spreadsheet, this error happens with column "CL." If you remove all the columns before "CL" then save the edited file, it imports successfully. So its not the data. Does Access have limitations with the number of columns being imported.
Importing an excel spreadsheet
- Thread starter crowegreg
- Start date
Rx_
Nothing In Moderation
- Local time
- Today, 16:48
- Joined
- Oct 22, 2009
- Messages
- 2,795
http://www.sqlservercentral.com/Forums/Topic906713-391-1.aspx
This is from a SQL Server site where Access is used for the import.
They claim Access is limited to 255 fields. SQL importing more from Excel is possible.
I seem to remember importing just under 100 columns with no problem.
Suspect that the amount of data in each field would also have some total character limitation too.
Maybe someone has the exact numbers to share. Generally, the wizards are for the 99% of situations. From there, a coding solution can be devised to do just about anything.
This is from a SQL Server site where Access is used for the import.
They claim Access is limited to 255 fields. SQL importing more from Excel is possible.
I seem to remember importing just under 100 columns with no problem.
Suspect that the amount of data in each field would also have some total character limitation too.
Maybe someone has the exact numbers to share. Generally, the wizards are for the 99% of situations. From there, a coding solution can be devised to do just about anything.
Similar threads
