Import file to Access 2002 database through a form interface.
Posted on 2011-03-25
Using a form, I would like the user to be able to import a file into an existing table. I usually hard code the import from a set location / file name, but this time I thought I would give a different method a try and see how it works out. I don't really want the user to get into the db to use the import function but thought I could put something on a form for them to naviagte through windows explorer to find the file they want to load.
I'll be importing two types of files (not into the same tables). 1 will be a .xls and the other a .txt (delimitted by seperated by | ).