| | |
copy data from excel to vb database
![]() |
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!!
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
)
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
) "Technological progress is like an axe in the hands of a pathological criminal."
![]() |
Similar Threads
- MS Access vs. MySQL (MS Access and FileMaker Pro)
- How to copy data from serial port to notepad (Visual Basic 4 / 5 / 6)
- Program 2 copy log file frm database (C++)
- how to copy data into array or memory ? (C)
- excel database linking with vb.net (VB.NET)
- Exporting Data from App To Excel c# (C#)
- Can this be done? (MS Access and FileMaker Pro)
- copy hd data (Storage)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: class module database
- Next Thread: Make Exe Into A Service In Windows
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows






