Range doesn't work during TransferSpreadsheet action in a macro (Access 2007)

[mkc80]

I am trying to export the result of two different queries in to the same sheet (say Sheet1) in a Excel workbook.
Each of the query results in two columns.

Here are the Action arguments I have:


Transfer Type: Export
Spreadsheet Type: Excel Workbook
Table Name: Query Name
File Name: ..\...\Book1.xlsx
Has FieldName: Yes
Range: Sheet1!A2:B200

I get an error stating that its not a valid name, make sure it does not contain invalid characters or punctuation and that it is not too long.

I have tried giving just the range A2:B500 for query1 and D2500 for query2, but I get 'Table A2:B500 already exists and get nothing when Book1.xlsx is created.

[TG_W]

Can you build one query to combine the two you want to export? If not, you can export both out into the same workbook and feed a third worksheet in the format you want.