Import multiple tables records in one

[Chromium]

hi,

I have to do a job in Access 2003 but I really can't understand how... so any help is appreciated!. This is my objective:

I have multiple tables with the same structures, column names and no primary key. I can not change this structures: it's provided by my costumer. Every two weeks two-to-six new tables are sent to me, and a progressive names is used for store this tables. es:

0xxx_STR_LOAD_GTPyyyyy

where x and y are numbers. x is a progressive numbers assigned by us, y are the progressive number of our costumer.

All those tables have to be inserted into a unique table, and some colums name have to be changed from source to destination. Since now it is done one by one via Add query, manually.

I'm looking for a way that allow us to do this job via one macro or sub, choosing only the last inserted tables every times.

Someone could help?

thanks in advance,


Lorenzo

 

[FoFa]

Typically we do this by using a common (per format) import table. Than using one or more queries to place that data where it belongs.
The advantage is you clear out (delete all query) the "work" table before importing. So you are only dealing with the current data.
Now how you decide to do that is more of what your requirements are. A lot of times I will setup a form, and let them choose the file to import via the normal windows FILE OPEN dialog.
Search the forums for that code if you desire.