A question re importing tables 1

[VickyC]

hi - I routinely have to import a set of 25 tables from one mdb file into another one. It's always the same tables. Is there a way to automate this, say by using VBScript?

Thanks for any clues
Vicky

 

[PHV]

How do you do that manually ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[VickyC]

by File / Get External Data / Import...

 

[PHV]

So, use the the DoCmd.TransferText method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[VickyC]

hi PHV - I'm trying, but I just don't understand this. I'm not moving data into existing tables, but I want to import a set of tables (also some modules) from one mdb file into another. Because I have to do this repeatedly, I was hoping to have a script, say, that would automate the process. Hope this makes sense.

much thanks
Vicky

 

[PHV]

What about the DoCmd.TransferDatabase method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[VickyC]

hi PHV - that's it. Thank you.