import csv files without extension

  • Thread starter Thread starter Mike D
  • Start date Start date
M

Mike D

I am trying to import csv files that do not have an extension. The path
changes in accordance with the department i am working with. the Name code
works with changing the extension, but i have to have the files in a specific
path. is there a way to use the get file command to input the path where the
data is stored.
 
You could just type the path into a text box, then refer to the value of the
text box in VBA as the path. Or, if you have a predetermined path for
different file types, you can have different paths stored as text in a table,
and then look up the appropriate path at runtime.

If, however, you want runtime control over finding the path, you can do even
better than that. You can have a browse button that will allow you to browse
to & select the folder. Look here:

http://www.mvps.org/access/api/api0002.htm
 
I'm not sure you'll be able to import the files unless you rename them to
have an extension, or follow the instructions in the following KB articles:
http://support.microsoft.com/?id=245407 and
http://support.microsoft.com/?id=306144

I know the KB articles only mention Access 2000, but it applies to all
versions of Access. It'll be the same registry keys for Access 2000, 2002,
2003 and 2007 using MDB format. Afraid I don't remember what the registry
keys are for ACCDBs.
 
Back
Top