Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sharmasumit45
Starting Member
9 Posts |
 Posted - 2008-01-23 : 00:29:11
|
| Hi,I need a help.I want to read the excel file in vb6.0 and compare the contents from the databse data fields .If they already exits leave it and update it otherwise insert a new record in the database.I want to read the excel using recordset and than convert that to array so that database data which is also comes in array can be compared. thanks in advancesumit |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-02-17 : 11:17:13
|
I suggest you import the spreadsheet into a temporary table on your database. The manipulation will be far easier (not to mention quicker!) on the databse side, rather than your application code.
George<3Engaged! |
 |
|
|
|
|
|
Vb array help