Importing Excel data

[mimivdg2002]

I would like to click on a button on a form (after specifying a file name) and be able to automatically import an Excel file into an Access database. How should I go about doing that? Some code examples would be much appreciated.

Thanks
M

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886