Mike,
How do I set up an Access datasource to point to an excel
datasource.
Brian
-----Original Message-----
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: Thursday, 19 June 2003 12:40 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Excel datasources
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/
---
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/
