Export multiple Queries to same Workbook Cant overwrite Content (1 Viewer)

Wapug

Registered User.

Local time

Today, 12:05

Joined

Apr 14, 2017

Messages

51

• May 22, 2018

• #1

I have an access db where I have written code to export the results of three queries to an excel workbook. The workbook will contain, or may contain data from previous exports and I would like to have the new data from my db overwrite the existing data in the workbook.
I have used the TransferSpreadsheet method to export the three queries. How can I add code that will delete any existing data on the three tabs in the target workbook?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qBacon", strpath

 

Ranman256

Well-known member

Local time

Today, 12:05

Joined

Apr 9, 2015

Messages

4,337

• May 22, 2018

• #2

The export does not erase the previous data.
Can you just erase the workbook, then export?

 

June7

AWF VIP

Local time

Today, 08:05

Joined

Mar 9, 2014

Messages

5,470

• May 22, 2018

• #3

Bing: access export to excel and overwrite

One approach https://answers.microsoft.com/en-us...ing-data/fc1ae248-6353-4c3a-b44a-e41dd6e969a8

 

M

Mark_

Longboard on the internet

Local time

Today, 09:05

Joined

Sep 12, 2017

Messages

2,111

• May 22, 2018

• #4

MMmmmmmm......qBacon......

 

Wapug

Registered User.

Local time

Today, 12:05

Joined

Apr 14, 2017

Messages

51

• May 22, 2018

• #5

Ranman256 said:

The export does not erase the previous data.
Can you just erase the workbook, then export?

Click to expand...

I don't want to delete the entire workbook because it contains multiple other sheets with information that is needed.