How to import a text file with more than 255 fields into Access

[OBP]

I deliberately used the "-" instead of Null values as it shows that all of the Fields have been translated, but I have now set it to "".
I have added the LoanNo field to the 2nd table in place of the Autonumber field.

[winxmun]

Hi OBP,
Yeh! Successfully downloaded! tks a lot!!!
You are great!