connection string to another server(not an sql database)

[user1980]

I would like to access an excel file form an asp page. I am using the connection string as,

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""c:\Test\Modified.xls"";Extended Properties=""Excel 8.0;HDR=NO;IMEX=1"""

I would like to know how can I put the server name, user name and password and how.....

[jhardman]

I think I would use a dsn for this. Have you ever set up a dsn before?

Jared

[user1980]

thank you for the response..I have never set up DSN....could you please let me know where can I find a good tutorial for that..thanks in advance