Programatically saving an Access table in an external Access db

[VBAguy22]

hello
I have a table that needs to be saved programatically in a different databse on lan using VBA.

How do I tell my db "Save table X using name Y in database c:\text.mdb"?

 

[WildHare]

Check out the good ol 'TransferDatabase' action. It will do exactly what you want.


JMH


If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[VBAguy22]

do you have an example of this function @ work?