Solved

Change The Microsoft Office Default Code Page

Posted on 2007-11-30
3
1,988 Views
Last Modified: 2010-09-22
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
Comment
Question by:Media01
3 Comments
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 total points
ID: 20382952
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
 
LVL 1

Expert Comment

by:Computer101
ID: 21186186
Forced accept.

Computer101
EE Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question