want to overwrite Excel workbook instead of appending new data

E

Excel

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!
 
T

Tushar Mehta

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!
Click to expand...
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
 
Top