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
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