RE: Microsoft Excel DSN
Excel DSNs are notoriouly horrible Make an Access Link Table and then use Access as the datasource - it also means that it's easier to replace the Excel spreadsheet > From: Tyagi, Badal [mailto:[EMAIL PROTECTED] > > I'm unable to make dsn in CFMX of Microsoft Excel sheet. If I > do it through ODBC Datasource Administrator, then CF does not > recognise it and throws error "Data source 'import' could not > be found. " > > Actually I'm uploading an excel sheet from client's m/c > renaming it to my dsn file name and then thru tag I > read the records in it. The same thing I did it w/ > tag but till date I'm unable to resolve MX issues related to > COM objects(working fine in CF5.0), so I thought doing it ODBC way. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Microsoft Excel DSN
Hi, I'm unable to make dsn in CFMX of Microsoft Excel sheet. If I do it through ODBC Datasource Administrator, then CF does not recognise it and throws error "Data source 'import' could not be found. " Actually I'm uploading an excel sheet from client's m/c renaming it to my dsn file name and then thru tag I read the records in it. The same thing I did it w/ tag but till date I'm unable to resolve MX issues related to COM objects(working fine in CF5.0), so I thought doing it ODBC way. regards, badal Tyagi, HCL Perot Systems, Noida, India ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4