when i export from access 2k table to excel, an apostroph character (') is 
inserted at the beginning of each text field.

ex: if a text field on Access = 123456789
    after exporting to Excel it will be = '123456789

Can any one help me to resolve this problem?

You may not want to.  Without the apostrophe character Excel will interpret
the value as a number and can do funny things to it.  I have data that I
export to Excel, example, 122E302, and without the ' it turns it into
1.22E304, a scientific number.

|-----Original Message-----
|From: Wajdi Sabeh [mailto:wsabeh@s...]
|Sent: Wednesday, January 15, 2003 12:17 PM
|To: Access
|Subject: [access] exporting from access 2k to excel
|
|
|when i export from access 2k table to excel, an apostroph character (') is
|inserted at the beginning of each text field.
|
|ex: if a text field on Access = 123456789
|    after exporting to Excel it will be = '123456789
|
|Can any one help me to resolve this problem?
|

Thank you Leo but when we work directly in excel we don't need to put an
apostrophe to a text field except if that field will contain numeric
characters.
ex: to type 1234567890 in a text format cell, we must type '1234567890
but to type abcdefg we must not.
ps. this problem was not present in Msaccess97.
Regards


----- Original Message -----
From: "Leo Scott" <leoscott@c...>
To: "Access" <access@p...>
Sent: Thursday, January 16, 2003 8:28 PM
Subject: [access] RE: exporting from access 2k to excel


> You may not want to.  Without the apostrophe character Excel will
interpret
> the value as a number and can do funny things to it.  I have data that I
> export to Excel, example, 122E302, and without the ' it turns it into
> 1.22E304, a scientific number.
>
> |-----Original Message-----
> |From: Wajdi Sabeh [mailto:wsabeh@s...]
> |Sent: Wednesday, January 15, 2003 12:17 PM
> |To: Access
> |Subject: [access] exporting from access 2k to excel
> |
> |
> |when i export from access 2k table to excel, an apostroph character (')
is
> |inserted at the beginning of each text field.
> |
> |ex: if a text field on Access = 123456789
> |    after exporting to Excel it will be = '123456789
> |
> |Can any one help me to resolve this problem?
> |
>
>

Your specific example, "ex: if a text field on Access = 123456789", was a
numeric value.  That is why I responded to you in the manner I did.  If you
are just exporting text and not numbers you should ask that question next
time.

-----Original Message-----
From: wajdi sabeh [mailto:wsabeh@s...]
Sent: Thursday, January 16, 2003 11:27 PM
To: Access
Subject: [access] RE: exporting from access 2k to excel


Thank you Leo but when we work directly in excel we don't need to put an
apostrophe to a text field except if that field will contain numeric
characters.
ex: to type 1234567890 in a text format cell, we must type '1234567890
but to type abcdefg we must not.
ps. this problem was not present in Msaccess97.
Regards


----- Original Message -----
From: "Leo Scott" <leoscott@c...>
To: "Access" <access@p...>
Sent: Thursday, January 16, 2003 8:28 PM
Subject: [access] RE: exporting from access 2k to excel


> You may not want to.  Without the apostrophe character Excel will
interpret
> the value as a number and can do funny things to it.  I have data that I
> export to Excel, example, 122E302, and without the ' it turns it into
> 1.22E304, a scientific number.
>
> |-----Original Message-----
> |From: Wajdi Sabeh [mailto:wsabeh@s...]
> |Sent: Wednesday, January 15, 2003 12:17 PM
> |To: Access
> |Subject: [access] exporting from access 2k to excel
> |
> |
> |when i export from access 2k table to excel, an apostroph character (')
is
> |inserted at the beginning of each text field.
> |
> |ex: if a text field on Access = 123456789
> |    after exporting to Excel it will be = '123456789
> |
> |Can any one help me to resolve this problem?
> |
>
>