Help needed on importing files

[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

[KTech]

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

[ltw85]

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

[leinad31]

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.

[ltw85]

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.