By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,072 Members | 1,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,072 IT Pros & Developers. It's quick & easy.

MS Access Script to import data from external mde database to mdb database

P: n/a
Hi,

Does anyone know of a way I can write a script that imports a table
from a particular .mde file? I don't seen any obvious way to do it as a
macro. Any suggestions if it can be done as a macro or as a written
module?

My ultimate goal is to have script that clears info out of 1 table in
an .mdb file, imports an identically structured table from a .mde file,
runs an append query I have in place to copy the data from the imported
table to the table in my.mbd file, and then delete the imported table.

Any help that could be provided would be greatly appreciated.

Best wishes,

George Hadley
gh********@yahoo.com

Feb 17 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
With DBEngine(0)(0)
.Execute "DELETE * FROM Suppliers WHERE SupplierID IN (SELECT
SupplierID FROM Northwind.mde.Suppliers)"
.Execute "INSERT INTO Suppliers SELECT * FROM
Northwind.mde.Suppliers"
End With

Feb 17 '06 #2

P: n/a
Is this code I would run as a module?

Feb 17 '06 #3

P: n/a
Yes

or you could use the strings in two separate saved queries.

Feb 17 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.