Yeap, this way works for Excel files too.

But as you noticed, you will need ColdFusion ODBC Agent installed on 
server. You should install it so CF can access this ODBC socket datasource.

Or, as Mark Smyth suggest, you might wanna look at a JDBC Driver for Excel.

--

Fabio Terracini



Duncan wrote:

>Ok I get where you are coming from and I would think that if the CF
>ODBC agent was installed and running it would probably work.
>
>Unfortunately this server doesnt have the CF odbc agent.  Any other
>ways around this without installing the odbc agent?
>
>
>
>On 5/6/05, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote:
>  
>
>>After setting up the OS-based ODBC datasource, you WILL need to go into CF
>>Admin and create a CFMX DSN that points to your ODBC DSN by name, and supply
>>the appropriate (if necessary) credentials.
>>
>>That is, you create an ODBC DSN via the Windows Control Panel and after that
>>a CF Administrator DSN that points to the original ODBC DSN. It's confusing
>>until you do it once. Don't hesitate to ask further questions. :)
>>
>>Laterz,
>>J
>>
>>On 5/6/05, Michael Bramwell <[EMAIL PROTECTED]> wrote:
>>    
>>
>>>If your using a windows box i reckon you can install the excel datasource
>>>as
>>>an obdc datasource without using cf admin
>>>start -> control panel -> administrative tools -> datasources (obdc) ->
>>>system dsn -> add -> choose microsoft excel driver -> next steps are
>>>pretty
>>>obvious.
>>>
>>>Haven't tried this for excel files but have had success with access
>>>databases via this method.
>>>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205837
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to