How to import files into access

[scotton]

The filedialog command box is working in my form so it opens the dialog box for the user to select which files they want to import and it shows it in a list box. I'm not sure what to do now to have it actually import the files into my database...this seems like it should be a no brainer, is it just a simple macro I need to trigger once they select the file?

TIA (Thank you in advance),

Sarah

 

[PHV]

Have a look at the TransferSpreadsheet or the The TransferText methods of the DoCmd object.

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