can't create import specification

J

Jim/Chris

That is correct. There is no import specification for
Excel spreadsheets. The format of the data is determined
by the first row of data. It is not the best way. You
have two ways around it.
1. Link to the table and use an append query
2. Import the spreadsheet to a temporary table and use an
append query.
In both cases make sure the first row in you spreadsheet
has the correct formating. I use a dummy first record to
insure formatting and delete after import.

Good Luck

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top