Results 1 to 5 of 5
Thread: Loading Massive Fixed Width File
Jun 3, 2003, 09:19 #1
- Join Date
- Jul 1999
- Jacksonville, FL
- 0 Post(s)
- 0 Thread(s)
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:
AA 0025 0130 Organization Name
Any help would be ENORMOUSLY appreciated!!!