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.