Change The Microsoft Office Default Code Page

Hi everyone

We're having problems with the importing of csv files into Microsoft Access 2003 and 2007 tables, the default Code Page is set to Western European (DOS), and is causing problems with diacritics (more specifically Circumflexs ("^")) . These are brought into the tables as pilcrows ("¶"), we get around this by changing the Code Page to Western European (Windows).

This works great, but with the amount of files we have to bring in this gets tedious.

So was wondering if there was a way of changing the default Code Page in Access 2003 & 2007 to Western European (Windows).

Thanks for all your help.
Media01Asked:
Who is Participating?
 
puppydogbuddyConnect With a Mentor Commented:
Try changing the Windows locale settings and see if that fixes the problem.  The Windows locale settings (in Win2K) are set in CONTROL PANEL, REGIONAL SETTINGS. Choose ENGLISH (UNITED STATES) as locale , and choose WESTERN EUROPE AND UNITED STATES as your language settings. Verify that you have SET DEFAULT and chosen ENGLISH (UNITED STATES).
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.