Expert: Rob Henderson - 1/29/2005

Question
Mr. Henderson,
First off, thank you for your time!
I have an ACSII (132 column...fixed length) file that I am trying to ulimately put into MySQL tables. But, I have several obstacles:
-File Size is 18 Mb, too big to transfer into MS Excel
-Even though all records are 132 columns, there are many different types of records (different column configurations).
Which means, I need to separate the data into many tables based on record type.
My problem is preparing the data for MySQL.  It needs to be delimited...so excel seemed like an easy choice.
Any ideas?
Respectfully,
Aaron Barber

Answer
Hi

If Excel is not an option what about using Access and importing into tables?

This would give you the organisational aspect of your data then when ready you can export the data into Excel csv files in more manageable chunks.

Does that help?

rob