468,505 Members | 1,927 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,505 developers. It's quick & easy.

connection string to another server(not an sql database)

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

Expand|Select|Wrap|Line Numbers
  1. 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.....
Mar 30 '10 #1
2 1540
3,405 Expert 2GB
I think I would use a dsn for this. Have you ever set up a dsn before?

Apr 1 '10 #2
112 100+
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
Apr 5 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Takuon Soho | last post: by
2 posts views Thread by bylum | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.