TransferSpreadsheet seems to corrupt spreadsheet

[Randy Harris]

I'm using TransferSpreads heet to transfer data from A2K to an Excel
spreadsheet that has some pivot tables in it. It seems like it is working,
but when I open the spreadsheet, it gets an error (always asks if I want to
send a message to Microsoft). I can't figure out how to get the data into
the spreadsheet. Anyone run into this or have a suggestion?

[Randy Harris]

Re: TransferSpreads heet seems to corrupt spreadsheet

I've not been able to get around this problem using TransferSpreads heet. I
cobbled around it by pushing the data over one cell at a time. It works but
is very slow relative to TransferSpreads heet. Anyone have a suggestion how
I might speed up the process?


"Randy Harris" <randy@SpamFree .com> wrote in message
news:oAtEc.3060 4$eH1.14526265@ newssvr28.news. prodigy.com...[color=blue]
> I'm using TransferSpreads heet to transfer data from A2K to an Excel
> spreadsheet that has some pivot tables in it. It seems like it is[/color]
working,[color=blue]
> but when I open the spreadsheet, it gets an error (always asks if I want[/color]
to[color=blue]
> send a message to Microsoft). I can't figure out how to get the data into
> the spreadsheet. Anyone run into this or have a suggestion?
>
>
>[/color]

[Pieter Linden]

Re: TransferSpreads heet seems to corrupt spreadsheet

A quick check at AccessWeb turned up this:

http://www.mvps.org/access/bugs/bugs0024.htm

TransferDatabas e Causes Page Fault If Object Exists

You may experience a GPF when trying to export an object to another
database by using TransferDatabas e method. This page fault occurs if
the destination object (any valid Access object type) already exists.

The only solution at present is to use Automation to start a new
Access instance and delete the destination object before issuing the
TransferDatabas e command.

Or try this method:

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

[Randy Harris]

Re: TransferSpreads heet seems to corrupt spreadsheet

"Pieter Linden" <pietlinden@hot mail.com> wrote in message
news:bf31e41b.0 407011850.5ba45 99e@posting.goo gle.com...[color=blue]
> A quick check at AccessWeb turned up this:
> http://www.mvps.org/access/bugs/bugs0024.htm
>
> TransferDatabas e Causes Page Fault If Object Exists
>
> You may experience a GPF when trying to export an object to another
> database by using TransferDatabas e method. This page fault occurs if
> the destination object (any valid Access object type) already exists.
>
> The only solution at present is to use Automation to start a new
> Access instance and delete the destination object before issuing the
> TransferDatabas e command.
>
> Or try this method:
> http://www.mvps.org/access/modules/mdl0035.htm[/color]

Pieter, I feel I owe you a beer! Your suggestion was tremendously helpful.
I still can't use TransferSpreads heet, however, the AccessWeb example code
used the CopyFromRecords et method, which helped. The time to transfer the
data into the spreadsheet was reduced by more than half! Thank you.

Randy Harris