Leading Apostrophe (') when exporting from Access Query

NELMO

New Member
Joined
Jun 7, 2005
Messages
9
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?

Thanks in advance

Nelmo
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,765
Members
410,704
Latest member
Cobber2008
Top