Import Tables 1

[barbola]

I posted this under Access Modules, not sure that was the right place.

I have two Access db's and I import tables from one to the other using Get External Data. I know I can automate this using VBA but only to the point where the user has to select the file and the tables.

I figured out the rest, how the user can verify the data and then I coded it to rename the tables.

Can I get the code to select the file and the tables automatically?

Thanks!
Barb E.

 

[gol4]

You should be able to automate this whole process easily. See the transferdatabase method under Access help.

 

[barbola]

Thank you this works. I had been using TransferText.


Thanks!
Barb E.