Подключаемся к Excel

Пример подключения к Excel

Standard (Excel)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;

Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

Полезные Строки подключения всегда можно найти здесь.

Connect SQL Server  |  Oracle  |  MySQL  |  Access  |  Excel

·         Access

·         Active Directory

·         AS/400

·         Caché

·         Composite Information Server

·         ComputerEase

·         DBF / FoxPro

·         DBMaker

·         DSN

·         EffiProz

·         Empress

·         Excel

·         Exchange

·         Filemaker

·         Firebird

·         HTML Table

·         IBM DB2

·         Index Server

·         Informix

·         Ingres

·         Integration Services

·         Interbase

·         Intuit QuickBase

·         Lightbase

·         Lotus Notes

·         Mimer SQL

·         MS Project

·         MySQL

·         Netezza DBMS

·         OData

·         OLAP, Analysis Services

·         OpenOffice SpreadSheet

·         Oracle

·         Paradox

·         Pervasive

·         PostgreSQL

·         Progress

·         RSS / Atom

·         SAS

·         SharePoint

·         SQL Azure

·         SQL Server

·         SQL Server Compact

·         SQLBase

·         SQLite

·         Sybase Adaptive

·         Sybase Advantage

·         Teradata

·         Textfile

·         UDL

·         UniData

·         UniVerse

·         Valentina

·         Vertica

·         VistaDB

·         Visual FoxPro

·         Windows Azure Storage

·         ZIM