ADO ConnectionString Excel: Difference between revisions

From AutoIt Wiki
Jump to navigation Jump to search
mNo edit summary
Line 3: Line 3:
The Provider supports the following arguments:
The Provider supports the following arguments:
; Data Source=
; Data Source=
: Path to the directory where the text file to be processed is stored
: Path & Filename of the Excel workbook you want to process


; Extended Properties="x"
; Extended Properties="x"
Line 10: Line 10:
;: Excel 12.0 Xml
;: Excel 12.0 Xml
:: Specifies the type of Excel file to process
:: Specifies the type of Excel file to process
;: 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"
|-
! Format !! Description !! Schema.ini Syntax !! Connection String Syntax
|-
| Tab Delimited || Fields in the file are separated by tabs || Format=TabDelimited || FMT=TabDelimited
|-
| CSV Delimited || Fields in the file are separated by commas (note that there should not be a space between the comma and the start of the next field name or value) || Format=CSVDelimited|| FMT=CSVDelimited
|-
| Custom Delimited || Fields in the file are separated by some character other than a tab or a comma (with one exception: you can't use the double-quote as a delimiter). For example, the asterisk is used as the delimiter || Format=Delimited(*) || FMT=Delimited(*)
|-
| Fixed-Length || Fields in a file take up a specific number of characters. If a value is too long, "extra" characters are chopped off the end. If a value is too short, blank spaces are appended to it to make it fill out the requisite number of characters. <br> The columns (fields) of the file need to be defined in a file named [[ADO_Schema.ini|Schema.ini]]. || Format=FixedLength || FMT=FixedLength
|}


;: HDR=
;: HDR=

Revision as of 09:43, 10 January 2014

This page is still a work in progress.

Arguments

The Provider supports the following arguments:

Data Source=
Path & Filename of the Excel workbook you want to process
Extended Properties="x"
"x" stands for one or multiple of the following extended properties separated by a semicolon:
Excel 12.0 Xml
Specifies the type of Excel file to process
HDR=
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=
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.

External links

Retrieved from "https://www.autoitscript.com/w/index.php?title=ADO_ConnectionString_Excel&oldid=12152"