I finally have access to Excel 2007, so I can open files with more than 65,000 records.
What I need to do is save an Excel file, using Excel 2007, as a fixed-format text file. (Right now I’m saving as .csv and importing into Access, then exporting as fixed-format text by defining the starting position of each column, and its length.)
I’ve tried saving as Text (Tab delimited), Unicode text, Formatted text (Space delimited), and Text (MS-DOS). Three of the four do not preserve the column positions. Formatted text does preserve the column positions, but apparently the file is too ‘wide’ and the last five columns are chopped off and appended to the end of the text file.
Is there a way to save a text file from Excel 2007 such that column positions are preserved AND the entire record is on one record instead of being chopped and appended?