Open from .csv (Excel), move columns and save as text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
IMPORT, don't LINK the .csv file into Access. Now you've got a real access
table which you can adjust. Then Export the table back to .CSV format.
 
Back
Top