Import

[coconutt]

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

 

[Klatuu]

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.

 

[coconutt]

I import the excell spreadsheet to an excisting table. (this spreadsheet has
the same fields in each instance) tHANKS

 

[Klatuu]

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.