I know this is not really an Access question, but I can't find a more
appropriate group, and I've received such great help here in the past.
I am trying create an asp page to read a text file one line at a time.
Then, use each line as an ID to look up info via an ODBC connection.
Everything works fine as long as the text file is in the same
directory as my asp page:
***
Set fs=Server.Creat eObject("Script ing.FileSystemO bject")
myPath = "Test.txt"
Set myFile=fs.OpenT extFile(Server. MapPath(myPath) ,1)
Do until myFile.AtEndOfS tream
Response.Write( myFile.Readline ) & "<BR>"
Loop
***
However, I want my users to use a text file that is not located on the
web server; rather local on their PCs. Is this possible? When I try:
myPath = "c:\myFolder\Te st.txt" in the above, I get "The Path
parameter for the MapPath method must be a virtual path. A physical
path was used."
I've searched Google and MS for clues about how to do this, but
nothing seems to work. Maybe the file must be on the server(?)
Any help would be greatly appreciated.
Thanks,
Alan
appropriate group, and I've received such great help here in the past.
I am trying create an asp page to read a text file one line at a time.
Then, use each line as an ID to look up info via an ODBC connection.
Everything works fine as long as the text file is in the same
directory as my asp page:
***
Set fs=Server.Creat eObject("Script ing.FileSystemO bject")
myPath = "Test.txt"
Set myFile=fs.OpenT extFile(Server. MapPath(myPath) ,1)
Do until myFile.AtEndOfS tream
Response.Write( myFile.Readline ) & "<BR>"
Loop
***
However, I want my users to use a text file that is not located on the
web server; rather local on their PCs. Is this possible? When I try:
myPath = "c:\myFolder\Te st.txt" in the above, I get "The Path
parameter for the MapPath method must be a virtual path. A physical
path was used."
I've searched Google and MS for clues about how to do this, but
nothing seems to work. Maybe the file must be on the server(?)
Any help would be greatly appreciated.
Thanks,
Alan