I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere.
I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered "best practice" in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4