ADO ConnectionString Excel - Revision history

Rt01 at 16:17, 17 January 2014

2014-01-17T16:17:30Z

← Older revision		Revision as of 16:17, 17 January 2014
Line 1:		Line 1:
	~~{{WIP}}~~
	=Providers=		=Providers=
	==Microsoft ACE OLEDB==		==Microsoft ACE OLEDB==

Rt01: /* External links */

2014-01-17T16:13:18Z

External links

← Older revision		Revision as of 16:13, 17 January 2014
Line 41:		Line 41:
	= External links =		= External links =
	* [http://www.connectionstrings.com/excel/ Connection string for Excel]		* [http://www.connectionstrings.com/excel/ Connection string for Excel]
			* [http://www.codeproject.com/Articles/37055/Working-with-MS-Excel-xls-xlsx-Using-MDAC-and-Oled Working with MS-Excel using MDAC and Oledb]
	[[Category:ADO]]		[[Category:ADO]]

Rt01: /* Arguments */

2014-01-17T16:12:20Z

Arguments

← Older revision		Revision as of 16:12, 17 January 2014
Line 35:		Line 35:
	;: MaxScanRows=		;: MaxScanRows=
	:: Excel does not provide the detailed schema definition of the tables it finds. It needs to scan the rows before deciding the data types of the fields. MaxScanRows specifies the number of cells to be scanned before deciding the data type of the column. By default the value of this is 8. You can specify any value from 1 - 16 for 1 to 16 rows. You can also make the value to 0 so that it searches all existing rows before deciding the data type. You can change the default behaviour of this property by changing the value of [HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows] which is 8 by default.		:: Excel does not provide the detailed schema definition of the tables it finds. It needs to scan the rows before deciding the data types of the fields. MaxScanRows specifies the number of cells to be scanned before deciding the data type of the column. By default the value of this is 8. You can specify any value from 1 - 16 for 1 to 16 rows. You can also make the value to 0 so that it searches all existing rows before deciding the data type. You can change the default behaviour of this property by changing the value of [HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows] which is 8 by default.

			;: ReadOnly=
			:: You can open a Workbook in readonly mode by specifying ReadOnly=True. By Default Readonly attribute is False, so you can modify data within your Workbook.

	= External links =		= External links =

Rt01: /* Arguments */

2014-01-17T16:09:11Z

Arguments

← Older revision		Revision as of 16:09, 17 January 2014
Line 30:		Line 30:
	:: Specifying HDR=YES means that the test file contains a header row. A header row simply means that the first row in the text file is a list of fields, with all subsequent rows containing the actual data.		:: Specifying HDR=YES means that the test file contains a header row. A header row simply means that the first row in the text file is a list of fields, with all subsequent rows containing the actual data.

	;IMEX=		;: IMEX=
	:Value 1 tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.		:: Value 1 tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.

			;: MaxScanRows=
			:: Excel does not provide the detailed schema definition of the tables it finds. It needs to scan the rows before deciding the data types of the fields. MaxScanRows specifies the number of cells to be scanned before deciding the data type of the column. By default the value of this is 8. You can specify any value from 1 - 16 for 1 to 16 rows. You can also make the value to 0 so that it searches all existing rows before deciding the data type. You can change the default behaviour of this property by changing the value of [HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows] which is 8 by default.

	= External links =		= External links =

Rt01: /* Arguments */

2014-01-10T11:02:40Z

Arguments

← Older revision		Revision as of 11:02, 10 January 2014
Line 23:		Line 23:
	::* Excel 5.0: Excel 5 to 95 (xls-files)		::* Excel 5.0: Excel 5 to 95 (xls-files)
	::* Excel 8.0: Excel 97 to 2003 (xls-files)		::* Excel 8.0: Excel 97 to 2003 (xls-files)
	::* Excel 12.0: Excel 2007 or later (xlsb-files, binary format)		::* Excel 12.0: Excel 2007 or later (xlsb-files, binary format) or 97-2003 Excel workbooks (xls-files)
	::* Excel 12.0 Xml: Excel 2007 or later (xlsx-files, macros disabled)		::* Excel 12.0 Xml: Excel 2007 or later (xlsx-files, macros disabled)
	::* Excel 12.0 Macro: Excel 2007 or later (xlsm-files, macros enabled)		::* Excel 12.0 Macro: Excel 2007 or later (xlsm-files, macros enabled)

Rt01: /* Arguments */

2014-01-10T10:53:42Z

Arguments

← Older revision		Revision as of 10:53, 10 January 2014
Line 21:		Line 21:
	;: Excel x		;: Excel x
	:: Specifies the type of Excel file to process. This can be		:: Specifies the type of Excel file to process. This can be
	::* Excel 8.0: Up to ~~Excel~~ 2003 (xls) ~~file type~~		::* Excel 5.0: Excel 5 to 95 (xls-files)
	::* Excel 12.0 ~~Xml~~: Excel 2007 ~~and~~ later (~~xlsx~~) ~~file type~~		::* Excel 8.0: Excel 97 to 2003 (xls-files)
	::* Excel 12.0: Excel 2007 ~~and~~ later (~~xlsb~~) ~~file type~~		::* Excel 12.0: Excel 2007 or later (xlsb-files, binary format)
	::* Excel 12.0 Macro: Excel 2007 ~~and~~ later (xlsm) ~~file type~~		::* Excel 12.0 Xml: Excel 2007 or later (xlsx-files, macros disabled)
			::* Excel 12.0 Macro: Excel 2007 or later (xlsm-files, macros enabled)

	;: HDR=		;: HDR=

Rt01: /* Arguments */

2014-01-10T10:44:27Z

Arguments

← Older revision		Revision as of 10:44, 10 January 2014
Line 21:		Line 21:
	;: Excel x		;: Excel x
	:: Specifies the type of Excel file to process. This can be		:: Specifies the type of Excel file to process. This can be
	::* Excel 8.0: Up to Excel 2003 (*.xls) file ~~formats~~		::* Excel 8.0: Up to Excel 2003 (xls) file type
	::* Excel 12.0: Excel 2007 and later (.xlsx, .xlsb or *.xlsm) file ~~formats~~		::* Excel 12.0 Xml: Excel 2007 and later (xlsx) file type
			::* Excel 12.0: Excel 2007 and later (xlsb) file type
			::* Excel 12.0 Macro: Excel 2007 and later (xlsm) file type

	;: HDR=		;: HDR=

Rt01: /* Arguments */

2014-01-10T10:37:24Z

Arguments

← Older revision		Revision as of 10:37, 10 January 2014
Line 22:		Line 22:
	:: Specifies the type of Excel file to process. This can be		:: Specifies the type of Excel file to process. This can be
	::* Excel 8.0: Up to Excel 2003 (*.xls) file formats		::* Excel 8.0: Up to Excel 2003 (*.xls) file formats
	::* Excel 12.0 ~~Xml~~: Excel 2007 and later (.xlsx, .xlsb or *.xlsm) file formats		::* Excel 12.0: Excel 2007 and later (.xlsx, .xlsb or *.xlsm) file formats

	;: HDR=		;: HDR=

Rt01: /* Arguments */

2014-01-10T10:18:24Z

Arguments

← Older revision		Revision as of 10:18, 10 January 2014
Line 21:		Line 21:
	;: Excel x		;: Excel x
	:: Specifies the type of Excel file to process. This can be		:: Specifies the type of Excel file to process. This can be
	::* Excel 8.0		::* Excel 8.0: Up to Excel 2003 (*.xls) file formats
	::* Excel 12.0 Xml		::* Excel 12.0 Xml: Excel 2007 and later (.xlsx, .xlsb or *.xlsm) file formats

	;: HDR=		;: HDR=

Rt01: /* Arguments */

2014-01-10T10:12:15Z

Arguments

← Older revision		Revision as of 10:12, 10 January 2014
Line 19:		Line 19:
	: "x" stands for one or multiple of the following extended properties separated by a semicolon:		: "x" stands for one or multiple of the following extended properties separated by a semicolon:

	;: Excel ~~12.0 Xml~~		;: Excel x
	:: Specifies the type of Excel file to process		:: Specifies the type of Excel file to process. This can be
			::* Excel 8.0
			::* Excel 12.0 Xml

	;: HDR=		;: HDR=