Open from .csv(Excel) move columns & export to text

[Forrestm]

I have a .csv file from a customer, it is there own software, when they send
it to me it is converted to .csv in Excel. Excel can't open the complete file
because it has 137,000 line items. I can open it in Access 2003 and save it
as a text file in order to upload it to my website, but the columns need to
be rearanged. Since it is a linked database, even if I move the columns in
the Access database and save it, it doesn't move the columns in the database
for the upload. I can't open it in Excel and arrange the columns because
Excel can only open a portion of the file (65,000 line items).
Any ideas?

 

[Frank H]

Could you not read the file in sequentially, separate the
fields, (i assume as it is a .csv file it has
recognisable separators) and write them to another .csv
file with the fields rearranged in the order you wish
then link to the new file ?

Frank H

 

[Van T. Dinh]

Try creating a Query based on the "linked Table" with the
Columns arranged in the order you want (and if required,
Records sorted the way you want) and then export this
Query to a csv file.

HTH
Van T. Dinh
MVP (Access)

 

[Forrestm]

I think I understand what your are writing, but the main problem is that I
can't open the complete .csv file as a database and rearrange the columns
with Excel due to Excels 65,000 line item limit. Is there another database
program I could use that is capable of handling 137,000 line items?