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