I am having a problem with tab delimited reports downloaded from Amazon. I have them saved in a directory, and that directory contains a schema.ini file with the following lines.
[schema.ini] ColNameHeader=True Format=TabDelimited MaxScanRows=25 CharacterSet=OEM I then have an ODBC datasource set up for this folder and an ODBC socket set up for CF. Unfortunately CF queries these files as comma delimited, which they are not, and it screwes up the result set. It works fine if I add [395056231.txt] ColNameHeader=True Format=TabDelimited MaxScanRows=25 CharacterSet=OEM To the schema.ini file but this directory will get a new file every 15 minutes and I don't want to have to modify the schema.ini file 96 times a day when the default first group should work. Any ideas how I get CF to read them as the TabDelimited files they are using a default setting? -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
