Lorenzo - Saving files in database is not a great idea instead save their path reference in database and place the files on web server file system BUT if you already have something like this in place and would like to leverage it - that's fine.
I would suggest Convert these excel files to base64 Encoded strings and Save them in CLOBS in database (memo field in MS Access) and retrieve them [ don't forget to use tobinary or BinaryDecode functions ]. Thanks. -Sandy Vohra -----Original Message----- From: Lorenzo Hills [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 9:19 AM To: CF-Newbie Subject: Re: Database Retrival >Assuming you have two different datasources for excel and access already >created in CF Admin..here is the code you might find helpful to your >requirement.. > >-------------------------------- ><cfquery name=select_excel datasource=select_excel> > Select * from excel ></cfquery> ><cfoutput query=select_excel> > <cfquery name=update_access datasource=update_access> > Update ACCESS > Set X1 = '#select_excel.X1#', > X2 = '# select_excel.X2#' > where access_id='#select_excel.id#' > </cfquery> ></cfoutput> >-------------------------------- > >Thanks. > >-Sandy Vohra >-----Original Message----- >From: Lorenzo Hills [mailto:[EMAIL PROTECTED] >Sent: Thursday, December 28, 2006 11:30 PM >To: CF-Newbie >Subject: Database Retrival > >Can you tell CFupdate query to upload a MSExcel spreadsheet information >into MSACCESS Database. Then write a cfquery to retrieve the spreadsheet >and display it a a table? Thanks for the response. My question was not clear. Allow me to explain n greater detail. I have item table. The item table has documents in it. These documents are excel files that I want to retieve when I do my query. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2380 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
