Leading Apostrophe (') when exporting from Access Query

Nelmo

Registered User.
Local time
Today, 04:49
Joined
Mar 13, 2001
Messages
17
I am exporting a query from Access 2000 to Excel 97 - 2000.
- There are 4 columns (3 text fields and a number field).
After exporting, the text fields data all display a leading apostrophe (') i.e Golf becomes 'Golf, Coil Pack becomes 'Coil Pack, the exported number field is OK.
Why is this? Is it an Access issue or Excel?

Thanks in advance

Nelmo
 

Users who are viewing this thread

Back
Top Bottom