• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2199
  • 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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