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:
AA	 0025	0130	Organization Name
0025 represents the start position and 0130 represents the field length.

Any help would be ENORMOUSLY appreciated!!!