Tab Separated file problem!

I am trying to select specific data from a file that is tab separated and insert that data as one record in a table in access...

sample file (not real figures):

Bleep Bleep Front Sheet - Fegslit Outwork

Out-Work Date: 99/99/2099

Branch Business 99/99/2099

Credit Debit

PLOP '7R' Settlement

Amount: 80,000,000.00 Transit Activity Electronic Summary 99,888,777.66

Transit Activity Cash Letter 9,999.99

NSP RR Debits 555,555.55

Bleeper RR Debits 0.00

True Free & Unapplied 200,200.00

Bleeper Day 1 Truncated 0.00

Heeper OS Debits 500,000.00

Sub Total: 55,555,333.22

(EDC Derived Value: 12,345,678.90 )

Matched DCVs from previous days Missing DCVs

Recycled DCVs Owned Today: 1,057,869.49 IUDD Loaded Today: 1,111,111.11

Adjustments Adjustments

Wrongly Claimed (+ve 0.00 Wrongly Claimed (-ve 0.00

Free Items - Clearing 200,000.00 Missing Items - Clearing 55,555.55

- Reject Encode/Repass: 10.00 - Reject 354.45

Subtotal: 888,888.88 Subtotal: 33,333.33

Gender Changes Gender Changes

Credits processed as Debits 645.65 Debits processed as Credits 0.00

Matching Errors: Data Differences/Errors:

Truncated Mismatch to 0.00 EDC to Bureau Difference: 0.00

EDC to eList Difference: 0.00

Missing Data 0.00

Total: 30,000,000.00 Total: 40,000,000.00

Difference: 1,000.00

Date Pinted: 99/99/2003 Page 1 of 1


If i import directy to access it puts it all on load of records

If any one can help or if you need me to give you more specific information then please let me know.

Thank You,

Tom Bates

p.s. the file tabs stay exactly the same every time exactly the same format each day!

You will need the field names of the text file on one line, with the data on the next. Then, if Access has an Import function, you should be able to import the file, which should allow you to map the DB fieldnames with the flat file fieldnames.

The problem is thats the file cannot be altered as it is altomatically sent from an email server everyday, and i want to make it so a 'no-brain' off the street can just come in and use it. Someone has already done it using vbscript.

Thanks,

Tom

Yeah - that was my next suggestion - just write a simple little ASP/VB script to process the file. I wouldn't have thought Access could have done it using it's import tools.

Arghh i see yes to get access to re jig the file so that it can understand it...ok i'll give it a shot.

Thanks,

Tom

You should be able to write some VBA code within access to read the file in as it is spit out of your other system... no re-jigging should be necessary.