Hi John,
You could write a few lines of CF to convert the CSV file into a query (using
CFHTTP), then cfoutput the query and insert each record into a db table. If there's a
way to use a CSV file as a datasource, I'm not aware of it. Even if there is a way,
you'd
be better off transferring the data to a proper db, with the speed advantages of
indexes
and other db features.
Gene Kraybill
LPW & Associates
John McGown wrote:
> 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?
------------------------------------------------------------------------------
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.
