ADO ConnectionString TextFile: Difference between revisions

Revision as of 08:17, 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.

The Provider supports the following arguments:

FMT: Using FMT=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.

@@ Line 5: / Line 5: @@
 The Provider supports the following arguments:
-;FTM
+;FMT
-: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 FMT=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.