Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 *** |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 *** |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking to Data in Microsoft Access | Links and Linking in Excel | |||
Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
get data from a text file and insert them in datasheet to show a chart in VBA | Excel Programming | |||
How to insert data into microsoft excel sheet using ODBC API | Excel Programming |