Excel Import Specifications

  • Thread starter Thread starter JohnV
  • Start date Start date
J

JohnV

Is there a way to create an impport specification for MS
Excel files? I know this can be done with text files.

Regards,
JohnV
 
No.
You have to "take your chances" each time.

There are many problems with importing Excel files.
If you build your spreadsheets properly, it works great.
If you have a haphazard mess then you will get various failures.

========================
One issue:
Since Excel is not a database, using "mixed" data types in a column causes a
problem when Access has to "guess" which one to use. Access examines the
first 15 rows (or so) and makes a guess. If you want to "force" Access to
guess a text data type then make the first entry in that column a text
value. The reason you get errors is that the first 15 rows are all numeric
and then the text data shows up after Access has already guessed the data
type to be Numeric.

The way to make a text value in your data of numbers is to include a
character!
e.g. 123A
 
Back
Top