Re: CSV files

[Arun Kumar <arunkumar13@YAHOO.COM>]

Maria,
In the CSV files if any one of the column with Char
type can have comma in its value then your CSV files
should have text qualifier around those columns.
EX.,
Field Name contains a comma between lastname and first
name (Martin,Steve).
This field in the CSV file should be covered with Text
qualifier like this "Martin,Steve" so that you would
know the comma between those text qualifier are
actually part of the field. In general double quotes
are used as text qualifiers but could be any character
which unlikely to appear as a part of the field
itself.

By reading your posting i wasnt sure what is the
problem you are facing but I hope this helps

Arun
--- "Brickl, Maria" <mbrickl@UWC.EDU> wrote:
> I have this program where it looks at this CSV file
> and inserts data into a
> table if there is new data. I got this error saying
> that the value was too
> large for the column. After looking at the data it
> was having problems with
> I realized that there are commas in the value and
> I'm wondering if that may
> be the cause of the problem. Does anyone know a work
> around for commas in
> values of a CSV file?
>
>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
> Maria K Brickl
> Information Systems Programmer/Analyst
> University of Wisconsin Colleges
> 780 Regent St, PO Box 8680, Madison, WI  53708-8680
> Phone: 608.265.2677 / Fax: 608.265.5770
>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*


__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com