How to insert the Raw data from a Text file to a Microsoft Access Using VB

  • Thread starter Thread starter Abhishek Ghosh
  • Start date Start date
A

Abhishek Ghosh

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?
 
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.
 
But i want to put that data into the Access file. not in the Excel file.
How to do that? can anybody has sample coding?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VB application 4
To protect user's privacy 1
VBA - retrieve data on last create named range from previous inserted named range 0
how do i bring a visual basic form to the spread sheet? 2
Can't find "Visual Basic" Toolbar on Excel 2007 Ribbon 3
Need help to read data from a text file 3
Excel VB to open Access DB 1
Control Word Files From Excel 1

Back
Top