J
JB
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
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