Question - MDE

[101287]

Need to know? I have a macro that copy a MDB file. The file has been change to an MDE database. Could I have a macro that copy the tables in the MDE file to my own MDB database?

Please advise. Thank you for collaboration.

Luis

 

[HarleyQuinn]

You could use something like:

With DBEngine(0)(0)
.Execute "INSERT INTO YourTable SELECT * FROM C:\Test2002.MDE.YourMDETable"
End With

YourTable would have the same fields as the table you're trying to copy from.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com