User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 402,907 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,103 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 2271 | Replies: 1
Reply
Join Date: Sep 2006
Posts: 24
Reputation: arvin2006 is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 1
arvin2006 arvin2006 is offline Offline
Newbie Poster

copy data from excel to vb database

  #1  
Jan 23rd, 2007
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!!
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Apr 2006
Location: Canada
Posts: 4,475
Reputation: John A is a glorious beacon of light John A is a glorious beacon of light John A is a glorious beacon of light John A is a glorious beacon of light John A is a glorious beacon of light John A is a glorious beacon of light 
Rep Power: 16
Solved Threads: 271
Moderator
Staff Writer
Featured Blogger
John A's Avatar
John A John A is offline Offline
Vampirical Moderator

Re: copy data from excel to vb database

  #2  
Jan 23rd, 2007
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 )
tuxation.com - Linux articles, tutorials, and discussions
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 3:38 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC