Huge file import is truncated

you'll definitely have to import it into access or something of the like

you can always break it up into ~65,000 file chunks and put into excel as different worksheets but that would require splitting it in access, or some other program that can accept that many rows.

sorry i misread your access comment. maybe try open office's equivalent, base. it's free, i've never personally used it so I have no feedback on it that way