I'm importing data from an Access DB to Excel. I have a macro that uses Refresh All Workbook Data. The rows that it is going to import to are full (from 1 to 65536), so it gives me an error that it can't insert new data.

Here's what I'd LIKE to do: instead of having it insert and try to "push" the data down, I'd like it to insert and just "overwrite" the old data.

Any suggestions on how to do this?