transferspreadsheet - export to excel

[Tony Rhodes]

I am using access 97 sr2 with Jet35sp3 installed

I am attempting to use a transferspreadsheet macro to save
2lines of data to an excell workbook saved in ver 97.

I want to save into a specific worksheet "Data_input" in
rows "a70 to ba71"

When running the macro I get Error 3010 "Table Data_input!
a70:ba71 already exists".

If I delete the worksheet name, the same error.

I have set the macro up as:
Export
Microsoft Excel 97
Individual - the select query used to generate the data
c:\bbs\beekeeper analysis.xls
Yes
Data_input!a70:ba71

 

[John Nurick]

Hi Tony,

According to Help, the Range argument causes TransferSpreadsheet to fail
when exporting to a spreadsheet. If you want to put data into specific
cells, the best way is usually to use VBA and Automation: see e.g.

http://www.mvps.org/access/modules/mdl0006.htm

http://support.microsoft.com/?id=247412