Thanks for all of the feedback.
Keep it coming...
Right now I am learning to use CFHTTP...
Couldn't I just use that to take their CSV and insert it into a table?
Or am I going to have issues when they have strings that contain quotes?
Thanks in advance...
John McKown, VP of Business Services
Delaware.Net, Inc.
> -----Original Message-----
> From: paul smith [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 11, 2000 11:47 AM
> To: [EMAIL PROTECTED]
> Cc: John McKown
> Subject: Re: Newbie Question - Creating Data Source for CSV text file
>
>
> For SQL7, this works fine inside CF:
>
> BULK INSERT Victor
> FROM 'D:\FR\FileResource\VictorJPGs\CSVs\July212000\101-200.csv'
> WITH
> (
> FIELDTERMINATOR=',',
> ROWTERMINATOR='
> '
> )
>
> best, paul
>
> At 10:28 AM 8/11/00 -0400, you wrote:
> >CF Gurus,
> >
> >I have a customer that is a car dealership. They want to put their car
> >inventory online.
> >The company that makes their inventory database tells me that
> the data store
> >is not ODBC compliant, but that they could output a CSV text
> file that they
> >will auto-FTP to our servers in the middle of the night. Not exactly the
> >most elegant solution, but it beats entering car data manually. :)
> >
> >Can I create an ODBC connection in the CF Administrator to use a CSV text
> >file as a data source? I tried but I could not get it to
> verify the data
> >source.
> >
> >Any Tips or place I could go to for more info?
> >
> >
> >John McKown, VP of Business Services
> >Delaware.Net, Inc.
> >
> >-----------------------------------------------------------------
> -------------
> >Archives: http://www.mail-archive.com/[email protected]/
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/c
f_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
