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