Computing.Net > Forums > Programming > VB.NET; ADO and Excel 2000

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

VB.NET; ADO and Excel 2000

Reply to Message Icon

Original Message
Name: mking (by mkingrey)
Date: November 29, 2005 at 08:09:06 Pacific
Subject: VB.NET; ADO and Excel 2000
OS: XP Pro
CPU/Ram: 1.4
Comment:

Hello,

I would like to use vb.net to take an excel file, convert specific data into variables and then write the data out to certain parts of another excel file. Can anyone tell me how to make this connection as if I was using Access and Jet 4.0 OLE DB.


Report Offensive Message For Removal


Response Number 1
Name: Chi Happens
Date: November 29, 2005 at 10:01:42 Pacific
Reply: (edit)

With an ODBC connection to the excel sheets, you don't need access or the jet driver. Simply connect to the Excel sheet like it was a database table, get your values, connect to the destination excel sheet and plug em in.

Chi

They mostly come at night...mostly.


Report Offensive Follow Up For Removal







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home








Do you have your own blog?

Yes
No
I did before
I will soon


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge
Poll History




Data Recovery Software