By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 834 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

How to export to excel

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Danny" <da********@hotmail.com> wrote in message news:<S3******************@news4.srv.hcvlny.cv.net >...
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


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
;-)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.