[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2158
  • Last Modified:

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.
0
Media01
Asked:
Media01
1 Solution
 
puppydogbuddyCommented:
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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now