I think it's supposed to be the name of the worksheet... which it looks like you're doing... but what's the '$'? Try renaming the sheet something like "test" and trying that.
Also, I think you may find that you'll have to set up a new DSN for each excell file (if they have different workbook names, maybe?)... I remember running across this once. Another user in the conversation on this subject a few days ago said that he was able to set up a generic excel DSN. I'll see if I can dig up that post for you. Chris Chad Gray wrote: > That did not work.. maybe I have it setup wrong. > > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel > Driver] Syntax error in FROM clause. > > <cfquery datasource="excelTest" name="test"> > SELECT * > FROM Sheet1$ > </cfquery> > > > > >> -----Original Message----- >> From: Peterson, Chris [mailto:[EMAIL PROTECTED] >> Sent: Thursday, December 21, 2006 12:44 PM >> To: CF-Talk >> Subject: RE: upload excel to update database >> >> 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:264780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
