About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
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.
