| re: How to export to excel
"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
;-)
| 
