>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:2379 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
