want to overwrite Excel workbook instead of appending new data

Hello,

I'm doing data import overnight. Now the new data is appended to the old
data. But I want to overwrite Excel workbook instead of appending new datato
the old data. Any idea? Thanks!

In article <[email protected]>,
[email protected] says...
> Hello,
>
> I'm doing data import overnight. Now the new data is appended to the old
> data. But I want to overwrite Excel workbook instead of appending new datato
> the old data. Any idea? Thanks!
>
Delete the existing data before importing?

Depending on how you are importing the data, does it have a
'overwrite' feature? A way to specify the target of the import?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions