copy data from excel to vb database

[arvin2006]

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!!

[John A]

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 ;) )