If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing Tables
I have a database which needs to import a table from databases that are
created by another system. My database checks the folder for any databases that have been created, and lists them in a file. I then import the table, append the records to another table and then delete the database individually. Is there any way I could automate the process and import to the same table? 1. Check for databases (variable Db names) 2. Import table (always 'partsummary') 3. Delete database. The code I currently use is below. Dim strPath As String strPath = Me.FileName DoCmd.TransferDatabase acImport, "Microsoft Access", strPath, acTable, "PartSummary", "t_PartSummary", False Kill strPath |
Thread Tools | |
Display Modes | |
|
|