Automatically importing Excel files

  • Thread starter Thread starter Fluff
  • Start date Start date
F

Fluff

I am trying to import excell files on a regular basis, ie
once a month to a table in access 2000, and need a way to
automate this process to allow the user to perform the
operation with a simple click of button. Are there any
examples of VB code or macro's which will perform this
operation?
 
Just put something like this behind a button.
You can use text boxes on a form to trap the variable data.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, strTableName,
strLocalDir & strLocalFileName, True
 
Or you could simply link the spreadsheet rather than
importing it. That way, you have "real time" data each
time you view the information in Access.

-----Original Message-----
Just put something like this behind a button.
You can use text boxes on a form to trap the variable data.

DoCmd.TransferSpreadsheet acImport,
Click to expand...
acSpreadsheetTypeExcel8, strTableName,
 
Back
Top