Re: transfer spreadsheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: ErnieT (ErnieT_at_discussions.microsoft.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 03:17:02 -0800

Thanks for this tip. But not out of the woods yet. I have confirmed that I'm
at MS Access 2000 (9.0.7616 SP-3 ) and my Jet 4 SP shows version 4.0.8618.0
(Security Bulletin MS04-014). I did try to install Jet 4 SP8 anyway and got
message saying that a lower version of this service pack was detected.. and
that I needed to have at least SP3 to be able to apply this SP. Is it
possible to be at version 4.0.8618.0 without SP8 applied? Also, so far I am
able to find Jet 4.0 SP3 to install?

Thanks Again ! Ernie

"Allen Browne" wrote:

> Sounds like this problem, which requires you to download the free service
> packs:
> ACC2000: When You Export an Access Report the Memo Field Is Truncated
> at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;281153
>
> Although the article does not say so, be sure to get the JET 4 Service Pack
> 8 as well. It also fixes many probems.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "ErnieT" <ErnieT@discussions.microsoft.com> wrote in message
> news:43852D78-8082-4AAC-B7E1-1763E8DA81A4@microsoft.com...
> > When running the docmd outputto or transferspread*** statements from
> > within
> > a module or macro the memo fields get truncated whether from a table or
> > query into excel. The query is a straight query no grouping, sorting,
> > calculating etc. When I use the menu to export the same table or query
> > everything comes over fine. But when trying to do this from a macro or
> > module
> > they are truncated. One obsevation: I can recreate the problem when
> > running
> > it from the menu by checking the formatting box. Looking at the output
> > from
> > using the statements it looks like that the output is indeed formatted. Is
> > there anyway to turn this off when running outputto or transferspread***
> > from a macro or module? I'm using Office 2000 professional. Thanks!
>
>
>

Quantcast