Hi, Claude... Yes, my VPS is Win 2003 Server, MySQL 5.
Interesting approach. Is there someplace I can read up on this approach? (Probably go google Microsoft Text Driver, huh... ;o) That would be nice to download the file automatically into a folder and then have a table created from it then run a scheduled query, etc., to parse out the data I want and put it into new tables. I'll check into it! Thanks! Rick > -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 17, 2008 5:04 PM > To: CF-Talk > Subject: Re: Tags useful to accomplish automating MLS direct feed into MySQL > DB? > > >>I will then import the tab delimited info and property filenames into > an MySQL database, and place the property photos into the appropriate > local server directory. > > Are you under Windows? > > The easiest (although not trivial) way to do it is to define an ODBC DSN > using the "Microsoft Text Driver (*.txt; *.csv)" > The DSN is defined on some directory in your system and any *.csv file > you drop in this directory > will become a "Table" in your DSN, a table you can make queries on. > From here, you can read all records and do whatever you need with them. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
