Automatically importing Excel files

[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?

 

[Joe Fallon]

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

 

[Renee Hajek]

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,

acSpreadsheetTypeExcel8, strTableName,