|
-
Sep 12th, 2005, 09:35 AM
#2
Re: Excel Spreadsheet
You can use ADO.NET at both ends. System.Data.SqlClient for SQL Server and OleDb for Excel. Check www.connectionstrings.com for the correct connection string for Excel. You use SQL statements for Excel just like any other database, except that you use sheet names, sheet names with cell ranges or named cell ranges in place of table names. Check MSDN for details.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote