Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / February 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ghadley_00@yahoo.com - 17 Feb 2006 15:32 GMT
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
ghadley_00@yahoo.com
Lyle Fairfield - 17 Feb 2006 16:41 GMT
   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
ghadley_00@yahoo.com - 17 Feb 2006 18:02 GMT
Is this code I would run as a module?
Lyle Fairfield - 17 Feb 2006 18:08 GMT
Yes

or you could use the strings in two separate saved queries.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.