Importing CSV files without CSV extensions

[Carlos]

I have a collection of CSV files that are generated by another application
whose extension is a 3 digit store number (ex: E1003080.100). How can I get
Access to recognize these files as CSV or even Text in order to import them
into my Access database?

Thanks in advance...Carlos

 

[Chris O'C via AccessMonster.com]

Change the extension to csv, txt or tab.

Chris
Microsoft MVP

 

[Carlos]

Thanks for your quick response Chris. I thought of that but it would require
us to manually change each of the extensions. Since we are only beginers and
are not programmers, is there another way to do have access recognize the
following types of files as CSV, ex: E1003080.100?

Thanks again...Carlos

 

[Douglas J. Steele]

http://support.microsoft.com/?id=306144 explains the update you'd need to
make to the registry, although it's probably easier just to use the Name
statement to rename your files before importing them. (You can name them
back once you've imported them)

 

[Carlos]

Hi Doug. What's a Name statement? Is it a function within Access?

 

[Chris O'C via AccessMonster.com]

Use vba:

Name "c:\E1003080.100" As "c:\E1003080.csv"

Chris
Microsoft MVP