MS Access - Auto-Update Data Type After Import?

Question

I am looking to automatically update the data type of numerous fields in MS Access once I have imported some Excel data into the database.Almost all fields are set to `Text` fields, and this would clearly affect any queries which rely on `date` data in order to run accurately.An example would be that a couple of the "Due Date" fields' data types are set to `text` post-import, whereas I require them to be set to `date`; I am able to update each data type manually, but would like to know if it is possible to automate this process to save time as I will be regularly importing data into this database.Many thanks.

Answer 1

Hello Kari, it may depend on how you are doing the import. If you are creating a table in Access when importing then you may not be able to control the format. If you create the table in Access and define the fields and types you should be able to import the data while controlling the format.

HTH

Jeff