Importing a Log file

[Steve Roberts]

Is it possible to add *.log to the Files of Type field in the import dialog
box?

I have a file that has a .log extension and is comma delimited. I need to
import the information automatically into a table every few weeks and would
like to automate the process so I can hand it off to someone else. I thought
it would be a piece of cake until I found out that I can't import .log
files. I can't rename the file every time I do this because that would be
too complicated for the end-user that I want to had this to.

Any suggestions?

Thanks

Steve

 

[aaron.kempf]

yeah i always thought that MS was crazy for doing things that way
it's like excel can import from any extension.. why can't access lol

i'd reccomend buidlig your own GetOpenFile filter

www.mvps.org/access and look in API

 

[Van T. Dinh]

See the Microsoft Knowledge Base article:

http://www.support.microsoft.com/?id=304206

 

[Douglas J. Steele]

That won't let him import a file with an extension of .log unless he follows
the steps outlined in the KB article Van posted.