User defined import into Access table 1

[Cordeiro82]

Hi,

I want to create a form with a text box that prompts the user to enter the path of the spreadsheet they want to import into access. However, I cannot figure out how to get Access to read and import the selected file once the path has been entered. Any help would be appreciated.

Thanks,

K

 

[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