Loading Massive Fixed Width File
Here's the deal. I have a fixed width file with roughly 1500 columns (it's from a vendor). I need to load this file into a database (I'll worry about normalizing later -- I just need to get this puppy into a DB so I can do some analysis). I have the file layout.
How in the heck can I use the file layout to help me create the table and import the data? I know there must be a way, I just don't have any clue where to start. I have access to MySQL and can script in VBScript if that helps -- but I'm sure there must be an easier way.
An example of a line from the file layout:
0025 represents the start position and 0130 represents the field length.
AA 0025 0130 Organization Name
Any help would be ENORMOUSLY appreciated!!!