.DIF Import in Access

[Joe Santacroce]

I have some log files in .DIF format. Excel will import
them with no problem, however, Access (97 or 2000) do not
support them.

Is there a routine or something available to import a .DIF
file out there?

Thanks!
..

 

[Alex Dybenko]

Probably the easiest way is to import via Excel - first import to excel,
save it, then import excel sheet to access. You can also automate this from
Access, creating new instance of excel, import file and saving it.

 

[Joe Santacroce]

Thanks...

I already have that automated. I launch Excel from Access,
import the .DIF file and then save-as the .xls and quit.
However, I'd like somethintg a little more elequent if
possible. It's too bad MS suppports .DIF with Excel but
not with Access.