• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

read and update excel sheet

Hi Experts
I would like to know if excel sheets can be connected to visual studio 2008 basic, read and update?
If yes please write the connection string for me.
Thanks
0
b001
Asked:
b001
1 Solution
 
ElrondCTCommented:
I always use Office Automation, rather than an OleDb or Odbc connection. A couple of pages that describe this:

http://support.microsoft.com/kb/301982
http://support.microsoft.com/kb/302094
0
 
CodeCruiserCommented:
This guy has written the connection string for you

http://www.codeproject.com/KB/vb/Excel_Connectivity.aspx
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now