Import Access->SQL Server: how not to append?

Hey,

Due to our frankly ridiculous database setup, we currently update our web database (SQL server) with an Access one, by doing a an import.

Now, I was SURE that not only would this overwrite existing data by default, but that there was a simple checkbox for selecting whether to append or overwrite. But I appear to be wrong.

I've just had to do it by:
Select database -> All Tasks -> Import Data
Select source, destination
Select "Copy table(s) and view(s) from the source database"
Selecting the transformation options for each individual table and checking "Delete rows in destination table"

This is pants. Am I just missing some obvious option at the beginning for "replace, don't append"??

You're right. Each one has to have the checkmark for Delete Rows. It's a pain, but it's also a free tool that came with the product. You could invest in other tools such as DBArtisan and see if they offer a better form of data transfer. If you're interested in bulk copying, you could setup a script to use the bulk copy option in SQL Sever but you'd have to put the server in single user mode, rebuild the indexes when you're done, etc...
-Dave