MS Access - Auto-Update Data Type After Import
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.
No comments:
Post a Comment