VB Text File Manupulation

[manojkalithodi]

How to work with Data in Excel and VB default
Access Database(Got from Adds-in)?.I have rows and
columns in Excel file
columnHeading1 columnHeading2 . . .
Row1 x y
Row2 z a
.
.
.

How to extract values(x,y,z,a..) from this excel into
a access data base using a VB front end form.

Please revert on how to work with Get Statement and Put statement
in Text File manupulation. How can we ask the interface to save a
data to a file(Say Test.txt)on click of a button.

Please revert ASAP

[rikshawdriver]

Since the question is highly generalized and the topic invloves more than one subject it is very difficult to give you a solution here. I would suggest you please go through the various database and other solutions offered in this site.

Still.. First, You include the Excel Reference in Your Project(Alt+P+N). Or use Createobject to create an instance of the desired Excel Worksheet. Open the database and the destination table. With the help of Range and Cells you would be able to get data from the Excel Worksheet.

Regarding the text file a better solution is to use FileSystemObject and Textstream objects.

Hope this helps