Use Sheet1$ -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2006 12:44 PM To: CF-Talk Subject: RE: upload excel to update database
Actually if I make a system dsn in windows linking to the Excel file then hook this into CF administrator. What is the table name of the worksheet? I tried the following and no luck <cfquery datasource="excelTest" name="test"> SELECT * FROM Sheet1 </cfquery> Also my MS Access idea linking to the excel it appears that if you update the excel file and query the datasource again the updated data in the excel file does not appear. I wonder if it is being cached and how to purge it. > -----Original Message----- > From: Chad Gray [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 21, 2006 12:30 PM > To: CF-Talk > Subject: RE: upload excel to update database > > Oh.... I see what you are saying... make the DSN in windows... then hook > into that with the Administrator... This works for me and is better then > what I tried below. > > In MS Access do an external link to an Excel file. Now the excel sheet is > in Access as a table that I can query with CF. I haven not tried changing > or updating the excel file to see what happens to the data returned in CF, > but it might work. > > > > > > -----Original Message----- > > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 21, 2006 12:15 PM > > To: CF-Talk > > Subject: Re: upload excel to update database > > > > >>In the server administrator? I don't see a datatype of excel? > > > > Aaaah this is the "pleasure" of working with JDBC! :-( > > I suppose you're under CFMX, under CF 5 all ODBC drivers were available, > > including Excel. > > > > With CFMX, you need to first create an ODBC datasource on your Excel > > file from Windows. > > THEN you can create the JDBC datasource on that ODBC DSN in the CF > > Administrator using the ODBC socket. > > > > I think MM should have kept the ODBC connection creation tool in the > > administrator and connect the datasource automatically through the ODBC > > socket. > > > > Now, if you're uner Unix or Mac, that's even another story. > > > > -- > > _______________________________________ > > REUSE CODE! Use custom tags; > > See http://www.contentbox.com/claude/customtags/tagstore.cfm > > (Please send any spam to this address: [EMAIL PROTECTED]) > > Thanks. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Talk/message.cfm/messageid:264771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
