>It doesn't sound as if you are doing an UPDATE, but rather a "replace
>all the contents" move. An UPDATE statement assumes that you have
>matching data between your source and targets, and can link to change
>the vaules of that data. It sounds as if you just want to delete the
>data, and start over.

>You have a couple of options, but they will differ between Access and
>SQL Server. SQL Server will allow you to issue multiple SQL statements
>in a single transaction by using the .; seperator. I don't believe
>that Access will.

Many thanks for the ideas.

I am indeed doing an UPDATE of all rows and columns
since the update excel sheet will never have ALL of the
rows that the Access database to be updated has.

SQL should handle it in one gulp (theoretically, heh heh)
rather than need mulitple queries. As the original
post shows, I can sure copy a table from Excel to Access
in one shot - so why not update it that easily (with the
proviso that I'm updating everything) too?

Thanks Again.
J