Import

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

Guest

I have a table I update with a excel spreadsheet. My question is, when I
import the spredsheet: is there a way to remove a record in the table if it
does not excist on the spredsheet?

Thanks
 
How do you do the update? Please give us some detail. It can be done, but
first, we need to know what it is doing now.
 
I import the excell spreadsheet to an excisting table. (this spreadsheet has
the same fields in each instance) tHANKS
 
I don't know if you are using TransferSreadsheet or linking to the
spreadsheet, but here is a basic concept.
Create another table with the same layout you are using now and import into
that( a transfer table). Be sure to delete the data in the transfer table
before the import. Once you have done the import, create 2 queries. First,
a Delete query that would delete matching records from the transfer table.
The an Append query to append the transfer table to the permanent table.
 
Back
Top