Opening a 70k record DIF file

A

Adam

Dear All,

does anyone have any ideas on how to open a .DIF file
into excel which contains 70,000 records?

Thanks

Adam
 
H

Harlan Grove

does anyone have any ideas on how to open a .DIF file
into excel which contains 70,000 records?
Click to expand...

DIF files are plain but formatted text files. It's theoretically possible to
read them from VBA as text files, entering records in multiple worksheets, but
you'd need to understand their layout.

How was this DIF file generated? Not by Excel, since it couldn't have generated
more than 65,536 records. Any chance you could use the source application to
generate multiple DIF files of 65,536 or fewer records each?
 
Top