ADO ConnectionString TextFile: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{WIP}} | {{WIP}} | ||
Text files files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating text files. | |||
==Arguments== | ==Arguments== | ||
| Line 6: | Line 6: | ||
;FMT | ;FMT | ||
:Using FMT=Delimited tells ADO that the | :Using FMT=Delimited tells ADO that the text file is comma delimited. 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. In that case you would use FMT=TabDelimited. There are other options, but these are the most common variants you'll run into. | ||
;HDR | ;HDR | ||
:Specifying HDR=YES means that the | :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. | ||
Revision as of 08:23, 7 May 2013
This page is still a work in progress.
Text files files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating text files.
Arguments
The Provider supports the following arguments:
- FMT
- Using FMT=Delimited tells ADO that the text file is comma delimited. 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. In that case you would use FMT=TabDelimited. There are other options, but these are the most common variants you'll run into.
- 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.