Previous YouTube RPA Developer Community Channel has suspended
Please subscribe my new channel for RPA Videos : https://www.youtube.com/channel/UCdYyxEEEOhYy0X1IE6TE5Rg?sub_confirmation=1
Please subscribe my new channel for RPA Videos : https://www.youtube.com/channel/UCdYyxEEEOhYy0X1IE6TE5Rg?sub_confirmation=1
Is Connection string for Office 2007 will work with all versions to the present ?
Is Connection string for Office 2007 will work with all versions to the present ?
Tagged:
Comments
Use the same string as for Office 2007 as that string will work with all versions to the present.
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";
Excel 97-2003
You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;Extended Properties="Excel 8.0;HDR=YES";
"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.
Let me know for any help