Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import using TransferText (Access97/2k)

    I decided to split a new db I'm working on.
    I use a routine to link tables when opening and un link when closing. This saves from using the linked table manager if they move the db to another folder....Anyway
    I import a monthly text file into the db using TransferText method and an import specification.
    Now that it will be split, I want to import the file to the backend. I didn't see anything in the syntax of the TransferText method to specify the path for the database. Is this possible or do I have to import the file, copy the table to the back end and then delete the table in the front end?
    Scott

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    Will importing into a linked table work for you?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    Paul,
    As long as it gets put into the back end.
    Scott

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    If the table is linked to the backend then the data will be in the backend.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    How do you import to a linked table?
    Scott

  6. #6
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    The same way you import to a table in the current db. I just tried it before my first post and it worked fine.

  7. #7
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    Paul,
    I'm working from the front end of the database using:
    DoCmd.TransferText acImportDelim, "RMAP_IMPORT", Format(strDATE, "MM/YYYY") & "_" & "RMAP30", "C:" & Format(strDATE, "MM") & "_" & "RMAP30.TXT"
    to import. It imports into the front end not the back end like I need it to.
    Scott

  8. #8
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    Right, you have to first create a table in the backend, link to it in the frontend then run your import into the linked table. i wasn't sure if this scenario would work for you which is what I was really asking in an earlier post. Does the table change each time you import or are you overwriting data?

  9. #9
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import using TransferText (Access97/2k)

    Paul,
    A new table is added each month with a new table name using the mm/yyyy_RMAP30 format.
    I guess I'll stick to the original idea of importing, copying to the back end and then deleting the original.
    Thanks,
    Scott

Posting Permissions

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