I just did it ok with EXCEL and CFMX. Set up a System DSN using the control panel. Use the Excel driver in WIndoze.
In the CFMX administrator, use the ODBC Sockets driver. In my case it found the excel datasource I set up in the Win Control panel minutes before. Select the excel datasource from the drop down list and select "trusted connection" worked for me. I guess if you can't use "trusted connection" for any reason you can show the advanced settings and put a connection string and/or Username/Password there. But it worked for me ok. Another way would be to set up an Access database as the datasource and link it to the spreadsheet. That would also have the advantage of being able to change the spreadsheet easily without having to disable the datasource. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Knott, Brian Sent: Wednesday, 18 June 2003 3:37 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Excel datasources Seems that it needs a username and password in the cf admin, even though the files does not require one. Any seem to work. Was able to do it without the connection string. Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Knott, Brian Sent: Wednesday, June 18, 2003 3:10 PM To: CFAussie Mailing List Subject: [cfaussie] Excel datasources Anyone know what the connection string is for an excel datasource in MX. Brian Knott QANTM Studio Senior Database Developer Ph (07) 30174331 Mob 0407572127 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
