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

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

VB.NET; ADO and Excel 2000

Reply to Message Icon

Name: mking (by mkingrey)
Date: November 29, 2005 at 08:09:06 Pacific
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.



Sponsored Link
Ads by Google

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

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.


0
Reply to Message Icon

Related Posts

See More







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


Sponsored links

Ads by Google


Results for: VB.NET; ADO and Excel 2000

VB.NET and C DLL's www.computing.net/answers/programming/vbnet-and-c-dlls/9509.html

VB.net Crash course www.computing.net/answers/programming/vbnet-crash-course/9149.html

VB syntax for an Excel macro www.computing.net/answers/programming/vb-syntax-for-an-excel-macro/2789.html