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