ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to insert the Raw data from a Text file to a Microsoft Access Using VB (https://www.excelbanter.com/excel-programming/377673-how-insert-raw-data-text-file-microsoft-access-using-vbulletin.html)

Abhishek Ghosh

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

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 ***

pb1

How to insert the Raw data from a Text file to a Microsoft Access Using VB
 
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 ***




Abhishek Ghosh

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


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?

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


All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com