thardyjackson
Registered User.
- Local time
- Today, 10:23
- Joined
- May 27, 2013
- Messages
- 45
I am periodically importing Excel files into access. Making the data usable requires removing spaces, parsing certain fields, adding datasource field, etc.
Currently, I am importing the un-formatted data into a staging table, cleaning it up with a query and then copying the updated staging table to the final table.
Is there a way to doing this in 1 query (get data into a query, process it and then write it to the final table) -- i.e., not have a staging table.
Thanks.
Access 2007
Currently, I am importing the un-formatted data into a staging table, cleaning it up with a query and then copying the updated staging table to the final table.
Is there a way to doing this in 1 query (get data into a query, process it and then write it to the final table) -- i.e., not have a staging table.
Thanks.
Access 2007