> 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.
You can use CSV files for ODBC datasource, but don't! The main reason is
that ODBC holds onto sources like that once it's got them
2 Solutions;
Open the CSV using CFFile - it's just a comma separated list per line
Make a link table in Access which talks to the CSV - this is the much
preferred solution as you can actually run SQL queries on the data
This all assumes that the column list and names stay the same, and only the
data itself changes
Remember also that quotes screw up CSV files royally - so if they have any
in their descriptions (as in 14" wheels)
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
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.
