Are you asking out of curiosity, or because you need to manage the data
types of an import?
If the latter, you will have more control if you first create the table in
Access with the data types you KNOW they must be. This requires knowing
what will be coming from Excel.
Then, when you import, import into that table.
Since Excel data may not be well normalized, another approach is to create a
all-text field table to import the data, then create a series of queries you
use to coerce the data into the correct data types and to append the data
into your more-permanent, and better-normalized Access table structure.
Regards
Jeff Boyce
Microsoft Office/Access MVP
