BlueTick
12-02-2005, 01:26 PM
I have .txt file that is converted from a word file about 40 pages long that I need to import into an Access table but is too complex for the wizard. This is a repetitive process occurring twice monthly.
1. I need to skip the header (first 10 lines).
2. Get the next line as the header field. (18 columns separated by a space)
3. Import the records (18 columns separated by a space)
4. Skip the footer (number of lines vary).
5. Repeat the process over and over until I reach the end of the .txt file.
Can any one assist with a code sample or db sample?
:banghead:
1. I need to skip the header (first 10 lines).
2. Get the next line as the header field. (18 columns separated by a space)
3. Import the records (18 columns separated by a space)
4. Skip the footer (number of lines vary).
5. Repeat the process over and over until I reach the end of the .txt file.
Can any one assist with a code sample or db sample?
:banghead: