Query to import and process an Excel file before writing to table

[thardyjackson]

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

 

[jdraw]

Probably not, but we don't know any of the details. You might consider writing some functions to do various manipulations and/or run queries in some defined order.
You could have an interface form, and some buttons. Clicking a button, or selecting something from a list/combo would trigger/invoke some action(s).

Good luck with your project.

 

[trkl]

if you do that in Ms Access 2010 then its very easy there.