How to populate Access DB from large flat file?

[Guest]

Hi, All
I have flat text file with fixed record lenght w/o record delimiter, i need
read this file and populate Access Database table, how can i achive this?
The Record count is 1465321 records: I have to keep connection open and just
each time i parse the record i have to add it to a table,
Any suggestions of a better way will be appreciated i can read the file, but
i don't know how populate table w/o open and close connection with each
record.

Please, advice any links or code example

 

[Otis Mukinfus]

Hi, All
I have flat text file with fixed record lenght w/o record delimiter, i need
read this file and populate Access Database table, how can i achive this?
The Record count is 1465321 records: I have to keep connection open and just
each time i parse the record i have to add it to a table,
Any suggestions of a better way will be appreciated i can read the file, but
i don't know how populate table w/o open and close connection with each
record.

Please, advice any links or code example

Is there a reason you can't use Access's import menu item? Access does imports
very well.
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com