Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    default name during import (97 sr2)

    I am doing an import from a text file into an access database table. I would like to create a default field in the table that would be populated with the name of the file I am importing. Is this possible?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: default name during import (97 sr2)

    You'd have to set the default value of the extra field to the name of the text file manually before importing, or use code to populate the field. As far as I know, there is no way to let Access do this automatically.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: default name during import (97 sr2)

    Can you give me help with the code. I do alot of VB but I really do not even know where to start with this.
    Thanks
    Cathy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: default name during import (97 sr2)

    Will you be importing several text files into the same Access table, or is is just one text file in one table?

Posting Permissions

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