Import code (Access 97)

Topic

New Reply

looking for some code which I can use an input box to designate a txt file location, to input the data into a new table. Thanks

Reply | Quote

Replies

Do you wish to import data to a table in VBA code behind a form?
Pat

Reply | Quote

I think your on the right track Patt. I really need to import an .HTM file into a table in access. I thought I could use a dialog or input box to select the file.

Reply | Quote

You can certainly use an inputbox to allow the user to type in a path, but what data are you trying to put into a new table? And are you trying to use a file open dialog like Windows uses or just an inputbox?

Reply | Quote

If you want to use the standard File Open dialog box, take a look at (for instance) post 188202. The code given there lets the user browse for a file and returns the path and file name of the selected file. You can then use this in the FileName argument of DoCmd.TransferText to import the text file.

Reply | Quote