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