ADO ConnectionString TextFile: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{{WIP}} CSV files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating CSV files. ==Arguments== The Provider supports the follo...") |
No edit summary |
||
| Line 8: | Line 8: | ||
:Using FTM=Delimited tells ADO that the CSV file is comma delimited. Although the comma is probably the most widely-used delimiter for CSV 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. | :Using FTM=Delimited tells ADO that the CSV file is comma delimited. Although the comma is probably the most widely-used delimiter for CSV 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 CSV 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 CSV 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 07:10, 7 May 2013
This page is still a work in progress.
CSV files accessed via ADO will be read only. ADO does not have a driver that supports writing to or creating CSV files.
Arguments
The Provider supports the following arguments:
- FTM
- Using FTM=Delimited tells ADO that the CSV file is comma delimited. Although the comma is probably the most widely-used delimiter for CSV 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 CSV 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.