want to overwrite Excel workbook instead of appending new data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help for excel macro ( to append records) 1
Importing data from an application to an Excel worksheet 1
Overwrite / Append files? 2
I want to append updated data to an Excel spreadsheet 1
Macro to combine worksheets data - overwrites existing 5
How to Create a Macro to Import External Data 0
How do I match and append/merge data from two spreadsheets? 2
Linking data within several Workbooks 1

Back
Top