Saving data to a database

[hawaiian1975]

I am working on a project for my job. What I want to do is be able to save data in my textboxes to a file and then be able to scroll backwards or fowards to view the data. How do I do that. I was able to do something similar in Delphi, but I am using VB 6 to create the project.

 

[johnwm]

You could try any of these, depending on how much text and several other factors.

Text file
Ini File
registry
.Mdb
SQL database

We may need to know more to give best advice - see faq222-2244

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[jonybd]

you can use mysql goto

http://www.mysql.com

or use microsoft access for your database software then use connection to database and you can solve your problem.

http://www.mysql.com/products/myodbc/manual.html

 

[hawaiian1975]

Most of the data will be numbers. First I want to save the data as a text document.

The document will have the following format:

Delta Exercise - 2003

Bumper# MI219
Axle 1 - 2135
Axle 2 - 2500
Total Weight - 4635
C/B - 102

Bumper# MI415
Axle 1 - 3100
Axle 2 - 2100
Total Weight - 5200
C/B - 98

 

[hawaiian1975]

Is there a way to save the data from the text boxes to an Excel spreadsheet?

 

[AndyWatt]

> Is there a way to save the data from the text boxes to an Excel spreadsheet?

Yes.

Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"A computer program does what you tell it to do, not what you want it to do." -- Greer's Third Law

 

[AndyWatt]

Oops! Sorry, that should've read:

Yes. See thread222-694640, for example. Or do a keyword search for "Excel ado"

Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"A computer program does what you tell it to do, not what you want it to do." -- Greer's Third Law