Help needed on importing files

Hi,

i am currently working on a database in access but i am facing some probs for the start portion of it. I need to import tables from different access databases into a common database. And upon importing, i hope to change the table name into a specific table name for each imported table.

This combining of tables into a common database is done on a monthly basis and every month, the similar sets of tables are saved as different file names like, buyer_0709 & buyer_0809 etc. I am facing some problems as i cant find a vba code to do this import and TransferDatabase function needs the file name to be the same.

thanks

could you write a short routine to grab the new file and rename it to the standard filename used by the TransferDatabase function?

Its possible but i am trying to figure out if there is any alternative that allows it not to change the file name.

Quote:

---

Originally Posted by ltw85

Hi,

i am currently working on a database in access but i am facing some probs for the start portion of it. I need to import tables from different access databases into a common database. And upon importing, i hope to change the table name into a specific table name for each imported table.

This combining of tables into a common database is done on a monthly basis and every month, the similar sets of tables are saved as different file names like, buyer_0709 & buyer_0809 etc. I am facing some problems as i cant find a vba code to do this import and TransferDatabase function needs the file name to be the same.

thanks

---

What value does this setup add to your business? There will be no end to it (capacity/storage, archiving multiple data sources instead of one, etc) and you have no common front-end code for all databases due to the table naming convention.

Might as well consider a long term solution such as realigning business processes to an OLTP database and importing historical data into a datamart/datawarehouse.

true, i get your point. Well there is a monthly reviews of business policies which are sent by the head office and the headings are named in such a way due to it's monthly nature.

And they usually send the whole set of data to the regional offices to do the necessary. Well i guess renaming the raw tables is the best alternative since it shldnt take more than 30s to do it.