Converting Access to Excel has commas before values???

divardo

New member
Local time
Today, 15:59
Joined
Sep 7, 2006
Messages
4
Hi, I am converting a database from Access 2002 to Excel 2002 but when converted each value in the spreadsheet has the value ' directly before it. Is there anyway around this problem.
 
Hi divardo

When you export a little check box usually not checked but shown in the picture "save formatted", attached which is checked, it will help removed the " ' ", that you mention.

Robert88
 

Attachments

  • export.JPG
    export.JPG
    31.3 KB · Views: 113

Users who are viewing this thread

Back
Top Bottom