copy data from excel to vb database

Expand Post »

hello there everyone! i just want to ask if what would be the process of copying data coming from the excel worksheet to a vb database? so that no need to encode data in the vb program, just insert the storage device then copy the data to the vb program database. is there anyone who can help me? thanks! i will appreciate all the responses you will give. God bless!!

Similar Threads

Exporting Data from App To Excel c# in C#
MS Access vs. MySQL in MS Access and FileMaker Pro
How to copy data from serial port to notepad in Visual Basic 4 / 5 / 6
Program 2 copy log file frm database in C++
how to copy data into array or memory ? in C

arvin2006

Reputation Points: 15

Solved Threads: 4

Junior Poster in Training

Offline

69 posts
since Sep 2006

Permalink

Jan 23rd, 2007

Re: copy data from excel to vb database

Don't know if it's possible to do it in plain old Visual Basic, but here's some articles on how to read and interact with Excel spreadsheets in Visual Basic.NET using the ADO framework:
http://support.microsoft.com/kb/316934
http://support.microsoft.com/kb/q301982/

Or you could write your own parser.
http://www.experts-exchange.com/Prog..._22001720.html
(The experts exchange answer you can get for free by scrolling down to the bottom of the page

)

John A

Team Colleague

Reputation Points: 2240

Solved Threads: 338

Vampirical Lurker

Offline

5,055 posts
since Apr 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: class module database

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Mose won;t scroll in VB6

DaniWeb Message

Cancel Changes

User Name
Password