Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2002
    Location
    Bloomsburg, Pennsylvania
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    transfertext - import in A2k (Access 2000 - SR1)

    A user was recently upgraded to Access 2000. Now when I try to run the following transfer text in vba I get an error, but only if the file I'm trying to import has a .dat extension. If I rename the file to .txt, it works fine. The statement in the vba is:
    DoCmd.TransferText acImportFixed, "Modified Import Specs", "Import", filename

    Before we converted the database (Access 97) we always used .dat files as the "filename". That's because they come from a scanner, and the extension it creates it as is .dat. Never had any problem. I just don't understand why the extension type would make a difference here because I'm passing the name of the file explicitly.

    The only thing I can find on knowledge base concerning this error ('3027' - Cannot update. Database or object is read-only) makes reference to ODBC connections and recordsets. I don't see how that would apply here.

    I'm stumped. Any suggestions?

    Thanks.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: transfertext - import in A2k (Access 2000 - SR1)

    Check out <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=86063&page=& view=&sb=&o=&vc=1#Post86063>this recent post</A> - I think it deals with the same subject.
    Wendell

  3. #3
    Lounger
    Join Date
    Apr 2002
    Location
    Bloomsburg, Pennsylvania
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: transfertext - import in A2k (Access 2000 - SR1)

    Thanks for the info. That works. Had to edit the registry and add the .dat extension. The article number is Q245407 if anyone else is interested.

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •