Results 1 to 4 of 4

Thread: TransferText

  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    TransferText

    In Access 97 I am using the following command to import a text file:

    DoCmd.TransferText acImportDelim, "CPR Import", "CPR_TBL_FULL", strPathName, 0

    This command works fine if I am running the db localy, but gives me a 3001, Invalid Object error when running from the network.

    Any ideas what whould cause this behavior?


    A second question. Why would one copy of the file import in about 4 minutes and an updated file take 30 minutes. The files are the same format and about the same size(90 meg).


    Thanks for your help.


    Richard Aheron
    raheron@hotmail.com
    Richard

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: TransferText

    Richard,
    The first question might relate to how strPathName is evaluated when you are running on the network. Are you using absolute paths e.g. File4fredmyfiles or are you using mapped drive letters? e.g. f:fredmyfiles. If you are using drive letters are the letters assigned across the network constant?

    I can't help with the second query.
    David Grugeon
    Brisbane Australia

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: TransferText

    I am using drive letters. I am reading the file from the C: drive of the machine running the code.

    The transfer seems to run if a new table is created, but not going into the table build to receive the data.

    The error number is 3001.

    Thanks for the help

    Richard Aheron
    raheron@hotmail.com
    Richard

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: TransferText

    I think it could be that "CPR Import" refers to a schema.ini file which is in your C:drive but not in the c:drive for the other computer.

    This would explain why you are OK if you create a new file.

    According to the help files you may not need a schema.ini file if you are using a delimited file which matches the table. If you were doing this you would leave the argument blank but include the extra comma.
    David Grugeon
    Brisbane Australia

Posting Permissions

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