Access 2002: How to import text file into predefined database

[dreman]

I have an application that I would like the user to import text file into a predifined database.
The text file has about 40 fields per records, delimited by a comma.
the database file has about 30 fields. (Need to ignore the rest)
I was able to complete a form with a view to open and select the text file But I do not know how to go about importing the data using access vb program.
Please advise or guide me via an example.
Thank you.
dré

 

[Bullschmidt]

Perhaps search Access Help for info on TransferText.

Best regards,
J. Paul Schmidt - Freelance ASP Web Developer

http://www.Bullschmidt.com

- Creating "dynamic" Web pages that read and write from databases...