merging fields, link, text boxes

[compooper]

How do you grab certain information (certain entire fields) from linked csv tables and merge them with an existing table in the database?



How do you take text that a user wrote in a textbox and put it in a table programatically?

[Rhino373]

Regarding your first question, you run an append query on the linked table for the specific records you want and append them to the existing table. (they still exist in the linked table and CSV.) You would need to run a Delete query to get rid of them.

As for your second question, assuming you built the memo field into your table, when a user types something in the CSV it would be updated in the Access table. If you haven't, Design view the table, add a field of type Memo and relink the CSV.