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!!
arvin2006
1
Junior Poster in Training
John A
1,896
Vampirical Lurker
Team Colleague
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/Programming/Programming_Languages/Visual_Basic/Q_22001720.html
(The experts exchange answer you can get for free by scrolling down to the bottom of the page ;) )
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.