CSV files and CFMX 6.1

[MikeLF]

I?m trying to access a csv file using the Microsoft Text Driver but since my
digit grouping symbol is comma, I get the following error when trying to access
the file:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver]
Text file specification field separator matches decimal separator or text
delimiter
I configured the ODBC DSN to treat all fields as characters but it doesn?t
matter. I still get the same error.
Does this mean that I can?t use csv files whenever my Windows grouping symbol
for numbers is a comma?.

Thanks,

[philh]

A comma is a comma. It can't be two things at once. If your file was given to
you in this format, how the heck could anyone tell where one number stops and
the next number begins?

Try delimiting your fields with tabs, or surrounding the values with quotes.

HTH,