On Jul 7, 11:10 am, "Karl" <some...@sbcglobal.bizwrote:
Quote:
I have an Access 2000 mde. It runs OK on computers with Access2007except
that it won't transfer data to an Excel worksheet usingTransferSpreadSheet.
>
Can I install the A2000 runtime on a machine that has Access2007on it and
force my mde to open using the A2000 runtime instead of Access2007?
We have found that the transferspreadsheet option has problems when
you use a query in Access 2007. (although perhaps we didn't select
the correct Excel format). Recommend copying the data to a temp
table, then exporting it.
