Transfer Spreadsheet problem

[hedgracer]

I have the following transfer spreadsheet code:

DoCmd.TransferSpreadsheet acExport, , "Reg_Inc_Stmt", _
"Z:\Accounting\SQLDataArchive\Inc_Stmt.xls"

The problem is that Reg_Inc_Stmt needs to be downloaded into the same spreadsheet around 5 times with different data in it each time. When I try this the data is overwritten each time in the first worksheet it creates. I have tried renaming the worksheet but the method still overwrites the data in that one worksheet that was created in the first download. Is there any way to creat separate worksheets for each of the five downloads? Thanks for any help in advance.

Dave

 

[SkipVought]

Hi,

What you describe, is the way that import is designed to work. If you need to had each download in your workbook, then you need to copy the data to a new sheet.

This entire process is an Excel process, and would best be addressed in forum707, where you could get help with Excel VBA, which is different in many respects from Access VBA, due the the differences in the object model.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hedgracer]

I forgot to mention that the transfer spreadsheet is from access 2003 not excel. I am transferring from access table to excel.

 

[PHV]

Can't you transfer an UNION query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

You could, as PHV suggested, query all 5 using a UNION query.

I assume you'll want to do something with each of the invoice data sets in Excel.

Since I'm an Excel guy, I'd do the whole thing in Excel, including whatever disposition of the invoice.




Skip,

_{Just traded in my old subtlety...
for a NUANCE!}