I never had the experience of dealing with Access.
However, if you wish to transpose data from text file to Excel file using
VB6, you may follow the steps below:
Prepare your text file - separate the data fields with delimiters;
In VB6, Split the delimited data into an array ;
Then open workbook/worksheet and transfer the array data onto the specified
column/row position by means of VBA coding.

Hope this will help you.

"Abhishek Ghosh" wrote in message
...

I need to develop a application using VB. I have created a database
using Microsoft Access. Now i want to insert the data from a text file.
I want to do that using VB. plz help me. How to develop that?


*** Sent via Developersdex http://www.developersdex.com ***