Import Data Types Shell

[BBAL20]

Is there a way to import raw data from excel into a pre-built/pre-defined
table in Access on import. My field names will be the same every time. I just
need to ensure that the data is imported with pre-defined data types for each
column every time.

 

[Jeanette Cunningham]

Yes,
there is a way to do this, but it is not very workable unless you can be
absolutely certain that the data types in each cell in the spreadsheet match
the data type for the field they need to go to in access.
You can use
transfer spreadsheet,
automation,
queries,
basic file in/out

The big catch is that if there is any chance that any data in excel in any
cell doesn't match the data type for the field it is going into in access,
you will need code to check each record.

Jeanette Cunningham