Opening a 70k record DIF file

  • Thread starter Thread starter Adam
  • Start date Start date
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
 
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?
 
Back
Top