Thursday, July 12, 2012

Koneksi Data Files (Connection strings for Excel 2007)

Xlsx files

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

Treating data as text

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";

Xlsb files

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;Extended Properties="Excel 12.0;HDR=YES";

Xlsm files

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;Extended Properties="Excel 12.0 Macro;HDR=YES";

Bridging to ACE OLEDB 12.0

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

Excel file with header row

Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;

Excel file without header row

Data Source =c:\myExcelFile.xlsx;HDR=no;Format=xlsx;

Share : Koneksi Data Files (Connection strings for Excel 2007)

Related Posts

Koneksi Data Files (Connection strings for Excel 2007)
4/ 5
Oleh