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/cf-talk@houseoffusion.com/
>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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
