Reading a text file

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Alan

    Reading a text file

    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
Working...