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.