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

F

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?
 
A

Anonymous Coward

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Open from .csv(Excel) move columns & export to text 3
Excel CSV Files; Creating Of 3
Import Multiple CSV Files from Same Folder into Open Workbook 5
Converting excel to PDF, single page converts to multiple HELP! 1

Top