accessing Excel database

[Anon]

I need to use PHP to output the contents of a simple Excel spreadsheet, but I have no idea how. Help!

[crowezr]

You will need to setup a MS ODBC connection to the Excel database in Windows. You can then connect from PHP using the built-in odbc functions.

[Anon]

but what how can I connect to the other windows machine thru ODBC?
odbc_connect(DSN, userID, password)
I know the name of DSN but where can I specific the IP for that windows machine? Thanks for help.

[crowezr]

Are you using Windows as the Web server? If so, you specify the userID and password when you create the ODBC definition. If you don't specify one in the odbc, you just use $connection = odbc_connect("mydsn","","");

[Anon]

Nope, I'm using the other Linux machine as web server. And my MS-SQL ar located on Windows machine. Thanks.