Try HXTT.com's type 4 JDBC Excel driver. I've not used it, but I am using their Type 4 JDBC DBF driver (to access FoxPro). They also have an Access driver.
The advantage of these drivers is the Type 4 JDBC part. They eliminate the need to use the crappy not-ready-for-primetime-nor-will-it-ever-be JDBC-ODBC Bridge (or Type 1 JDBC Driver). Give it a shot. See what happens. I'm very happy with the DBF driver. It give me control over FoxPro free tables (.DBF) that FoxPro didn't even provide natively. Cheers, Chris Chad Gray wrote: > The problem I see with doing the windows DSN is the excel sheet gets locked. > > Even if a user were to upload a new one I doubt that CFFile will be able to > over write it. > > I started testing more with the MS Access linking to the excel sheet and I > like it better so far. The excel file is not locked and I was wrong in a > previous post. If I update the excel sheet and re-query with CF on the > Access database then the new data does get displayed. > > As long as the excel file does not lock I think I will continue to experiment > with the MS Access linking to the excel file. > > Thanks for the help! > > > > >> -----Original Message----- >> From: Christopher Jordan [mailto:[EMAIL PROTECTED] >> Sent: Thursday, December 21, 2006 1:22 PM >> To: CF-Talk >> Subject: Re: upload excel to update database >> >> 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:264786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
