Exporting text fields to excel- ascii 39 character

[Jaco]

Hello,

I've recently changed Accescc to ver. 2000 and I have a strange problem.

When I export text fields to Excel, strings in excel always begin with "'" character (ascii 39)
e.g.
string in Access table: "beer", the same string in excel (after export): "'beer". This "additional" chracter is visible only when you set focus on the cell.

What's going on?

Thanks for any help.

Jaco

 

[scking]

That is how Excel recognizes a string character. If Access exports a text field it should be read by Excel as a string. If a numeric value is passed from a text field that will also show up in Excel with a "'" character to indicate a text field.

Steve King
Growth follows a healthy professional curiosity

 

[Jaco]

I thouhgt so. Is there a way to avoid it? Some times it not to convenient for me to have cells with this extra character.

Jaco

 

[scking]

Not that I am aware of. If you wanted you could write a small Excel macro to format the field as text and remove the "'".

Steve King Growth follows a healthy professional curiosity