I'm trying to import a pipe-delimited txt file into Access 2007. It's a 1.7Gb Unicode file encoded UCS-2 Big Endian with a Byte Order Marker. Each line aprox 200 characters; about 8 million lines.
How can I import this in?
I've tried http://stackoverflow.com/questions/1376756/superfast-way-to-read-large-files-line-by-line-in-vba-please-critique
and get error 5:InvalidProcedureCallOrAr
gument on line "sString = Space([1.7Gb])"
I've tried http://www.vbforums.com/showthread.php?430424-Reading-a-Binary-File-into-Excel-using-VBA
but get error 7:OutOfMemory. Furthermore, if I restrict the import to an arbitrary smaller amount, every 2nd character is Null (Chr(0)), because of the Unicode presumably.
How can I import this file into a table?