Prev: How do I use mouse wheel in a form to scroll - worked in 03 not in
Next: Tabbing in Subform
From: JB on 24 Feb 2010 06:47
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




 | 
Pages: 1
Prev: How do I use mouse wheel in a form to scroll - worked in 03 not in
Next: Tabbing in Subform