Importing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone. One question: if I have a table, and let's say at the end of
the month I want to update (add or replace) the data in a certain field from
a CD, or floppy, is it possible to do it? I mean, add some sort of a button
that imports data in a selected field.
Thanx!
 
Yes, but it depends on if the data contains adds/updates / deletes and how
you want to handle conflicts (if at all). If so, consider replication,
otherwise you could simply create 3 queries. The first would do a delete
from local table where record not in CD table, and you can guess the other
2.

Or, if the table is purely a copy of the CD/floppy table, do a delete from
local table, followed by an insert from CD table.
 
Back
Top