Importing data

A

Alex

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!
 
J

JohnFol

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.
 
Top