How to export to excel

I am trying to export my access 2002 table to excel using transfer
spreadsheet. It works fine but in excel, there is an apostrophe before each
word in all cells.
How can I avoid this?

I tried exporting using a lower version and it works but then the memo
fields are truncated.

How can I fix this, or how can I export to excel using another method so
these aposts. are not there.

Thanks

"Danny" <dannywork5@hotmail.com> wrote in message news:<S3r3d.225$gR1.572947@news4.srv.hcvlny.cv.net >...[color=blue]
> I am trying to export my access 2002 table to excel using transfer
> spreadsheet. It works fine but in excel, there is an apostrophe before each
> word in all cells.
> How can I avoid this?
>
> I tried exporting using a lower version and it works but then the memo
> fields are truncated.
>
> How can I fix this, or how can I export to excel using another method so
> these aposts. are not there.
>
> Thanks[/color]

If you can write vba then you could transfer the table to a worksheet
by creating an array and inserting it directly into a new excel file

This is how I overcame the problem, if you can use the code I'll post
it tomorrow

infopimp
;-)

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