ADO ConnectionString TextFile - Revision history

Rt01 at 09:44, 10 January 2014

2014-01-10T09:44:52Z

← Older revision		Revision as of 09:44, 10 January 2014
Line 9:		Line 9:
	==Microsoft Jet OLEDB==		==Microsoft Jet OLEDB==
	Provider=Microsoft.Jet.OLEDB.4.0		Provider=Microsoft.Jet.OLEDB.4.0

	=Arguments=		=Arguments=
	Both providers supports the following arguments:		Both providers supports the following arguments:

Rt01: /* Arguments */

2014-01-09T21:04:49Z

Arguments

← Older revision		Revision as of 21:04, 9 January 2014
Line 18:		Line 18:
	: "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:

	;: ~~text~~		;: Text
	:: Specifies that a text file is to be processed		:: Specifies that a text file is to be processed

Rt01: /* Arguments */

2014-01-09T21:03:33Z

Arguments

← Older revision		Revision as of 21:03, 9 January 2014
Line 12:		Line 12:
	Both providers supports the following arguments:		Both providers supports the following arguments:

	; Source=		; Data Source=
	: Path to the directory where the text file to be processed is stored		: Path to the directory where the text file to be processed is stored

Rt01: /* Arguments */

2014-01-09T21:02:25Z

Arguments

← Older revision		Revision as of 21:02, 9 January 2014
Line 12:		Line 12:
	Both providers supports the following arguments:		Both providers supports the following arguments:

	; ~~Data~~ Source=		; Source=
	: Path to the directory where the text file to be processed is stored		: Path to the directory where the text file to be processed is stored

	; Extended Properties="x"		; Extended Properties="x"
	: "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:

			;: text
			:: Specifies that a text file is to be processed

	;: FMT=		;: FMT=
	:: This argument tells ADO which delimiter is used for the file. Although the comma is probably the most widely-used delimiter for text files, it's not the only one. Another popular delimiter is the TAB.		:: This argument tells ADO which delimiter is used for the file. Although the comma is probably the most widely-used delimiter for text files, it's not the only one. Another popular delimiter is the TAB.

Rt01 at 18:55, 8 January 2014

2014-01-08T18:55:57Z

← Older revision		Revision as of 18:55, 8 January 2014
Line 1:		Line 1:
	Text ~~files~~ files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating text files.		Text files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating text files.
	=Providers=		=Providers=
	==Microsoft ACE OLEDB==		==Microsoft ACE OLEDB==

Rt01: /* Arguments */

2014-01-08T17:13:03Z

Arguments

← Older revision		Revision as of 17:13, 8 January 2014
Line 15:		Line 15:
	: Path to the directory where the text file to be processed is stored		: Path to the directory where the text file to be processed is stored

	; Extended Properties="x;y"		; Extended Properties="x"
	: ~~The~~ following extended properties ~~can be set~~:		: "x" stands for one or multiple of the following extended properties separated by a semicolon:
	;: FMT=		;: FMT=
	:: This argument tells ADO which delimiter is used for the file. Although the comma is probably the most widely-used delimiter for text files, it's not the only one. Another popular delimiter is the TAB.		:: This argument tells ADO which delimiter is used for the file. Although the comma is probably the most widely-used delimiter for text files, it's not the only one. Another popular delimiter is the TAB.

Rt01 at 15:11, 8 January 2014

2014-01-08T15:11:36Z

← Older revision		Revision as of 15:11, 8 January 2014
Line 9:		Line 9:
	==Microsoft Jet OLEDB==		==Microsoft Jet OLEDB==
	Provider=Microsoft.Jet.OLEDB.4.0		Provider=Microsoft.Jet.OLEDB.4.0
	===Arguments===		=Arguments=
	~~The Provider~~ supports the following arguments:		Both providers supports the following arguments:

	; Data Source=		; Data Source=

Rt01: /* Microsoft.Jet.OLEDB */

2014-01-08T15:02:54Z

Microsoft.Jet.OLEDB

← Older revision		Revision as of 15:02, 8 January 2014
Line 7:		Line 7:
	You don't need to buy or install the Office suite, the components are available as a separate download.		You don't need to buy or install the Office suite, the components are available as a separate download.

	==Microsoft.Jet.OLEDB==		==Microsoft Jet OLEDB==
	Provider=Microsoft.Jet.OLEDB.4.0		Provider=Microsoft.Jet.OLEDB.4.0
	===Arguments===		===Arguments===

Rt01: /* Microsoft ACE OLEDB */

2014-01-08T15:02:41Z

Microsoft ACE OLEDB

← Older revision		Revision as of 15:02, 8 January 2014
Line 6:		Line 6:

	You don't need to buy or install the Office suite, the components are available as a separate download.		You don't need to buy or install the Office suite, the components are available as a separate download.

	==Microsoft.Jet.OLEDB==		==Microsoft.Jet.OLEDB==
	Provider=Microsoft.Jet.OLEDB.4.0		Provider=Microsoft.Jet.OLEDB.4.0

Rt01 at 14:47, 8 January 2014

2014-01-08T14:47:21Z

← Older revision		Revision as of 14:47, 8 January 2014
Line 1:		Line 1:
	Text files files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating text files.		Text files files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating text files.
			=Providers=
			==Microsoft ACE OLEDB==
			Provider=Microsoft.ACE.OLEDB.12.0
			With Office 2010, there are new drivers, the 2010 Office System Driver, which will be provided in both 32-bit and 64-bit versions. You can use these drivers to let your application connect to Access, Excel and text files in a 64 bit environment utilizing the new 64-bit drivers.

	=Arguments=		You don't need to buy or install the Office suite, the components are available as a separate download.
			==Microsoft.Jet.OLEDB==
			Provider=Microsoft.Jet.OLEDB.4.0
			===Arguments===
	The Provider supports the following arguments:		The Provider supports the following arguments:

	;FMT=		; Data Source=
	:This argument tells ADO which delimiter is used for the file. Although the comma is probably the most widely-used delimiter for text files, it's not the only one. Another popular delimiter is the TAB.		: Path to the directory where the text file to be processed is stored

			; Extended Properties="x;y"
			: The following extended properties can be set:
			;: FMT=
			:: This argument tells ADO which delimiter is used for the file. Although the comma is probably the most widely-used delimiter for text files, it's not the only one. Another popular delimiter is the TAB.
	:{\| class="wikitable"		:{\| class="wikitable"
	\|-		\|-
Line 19:		Line 31:
	\|}		\|}

	;HDR=		;: HDR=
	:Specifying HDR=YES means that the text 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 text 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.

	= External links =		= External links =