MS Access Import Files

  • Thread starter Thread starter Philip
  • Start date Start date
P

Philip

Hi, i have developed a database where i import comma
delimited files and from this catalog data. i am currently
using a macro to do this operation. it works fine however
i want to make it smarter and be able to read a field
stored in a table. when i go to the form and change this
feild it will be able to import different data from a
different directory to the selected area, hope this makes
sense
 
Hi Philip...
Could you use a common dialog control to show a file open dialog and then
return the commondialog.filename to a textbox? If your app isn't going to be
rolled out to various users that might have different versions of the
commondialog control on their systems, you wouldn't have to worry about
distributing the control with your app.
Also, if your app ordinarily opens the same csv file, you could save the
filename to the VBA settings of the registry. When the form load event
fires, you could read the value from the registry and populate the textbox
with the stored filename.

HTH,
Mike
 
Back
Top