Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    13

    Unanswered: Importing text file to access

    Hello,
    I need your help in the following:
    I have an external text file that containes of three filelds (Operand,Symbol,Comment).
    I built in access a corresponed table that has the same records,and linked it to another table that has more information about the Operand like (Operand descript ,Value,...).
    If I update in access table I'll export it to the text file to be updated after my changes,this is the easy side.
    The problematic side is the importing of the file to the table.If I change
    data in the text file the access table has to be updated also,so I am importing it,but access always append the file to the table and this is wrong.
    My question: is how I can make somthing similar to linking access table to text file?
    Maybe any one give me a link to a chatroom and time in order to get immediate solutions to the problem .
    Thanks allot and best regards...

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Try deleting your old table prior to reading in new data. Or if you are concerned w/ coordinating tables old and new. You may need to find out what is different in the new table and only add the new. For the latter method your find unmatched/duplicate query wizard should be a tool.

  3. #3
    Join Date
    Nov 2003
    Posts
    267
    What I would do is when you have an updated Text file you import it into a new table and either through queries and VBa routine, you compare the recors and make the proper changes. The assumption here is that you have a unquie identifier that stays the says and can be used to reference between you Orginal table and the new table.

    S-

  4. #4
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    You CAN link to a Text file.

    Select File >> Get External Data >> Link Tables

    and in the associated dialog box, under the Files of Type combobox, select Text Files.
    Ken

    Maverick Software Design

    (847) 864-3600 x2

Posting Permissions

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