Docmd.TransferText to update data
Posted
by every_answer_gets_a_point
on Stack Overflow
See other posts from Stack Overflow
or by every_answer_gets_a_point
Published on 2010-06-07T18:36:34Z
Indexed on
2010/06/07
18:42 UTC
Read the original article
Hit count: 120
i am using Docmd.TransferText
to import data from a text file into my access table.
i would like it to do the following:
- if the record already exists, then update it
- if the record does not exist then add it
how do i accomplish this?
currently i have this line:
DoCmd.TransferText acImportDelim, yesyes, "table3", "C:\requisition_data_dump.txt", True
© Stack Overflow or respective owner