Access Import

[HeinzW]

Hi
I am importing text files into an access db. Depending upon the contents of
the file uses the import assistent either the windows or the DOS codepage
which gives ablolutly unusable data when you work with german "umlaute".
I found where I can tell the assistent which codepage to use, but I have to
import about 30 tables very often.
Can anybody tell me where I can change the setting for it.
Thanks
Heinz

 

[John Nurick]

Hi Heinz,

The registry and schema.ini entries available for the text ISAM driver
are documented at
http://office.microsoft.com/en-us/assistance/HP010321661033.aspx
(there's also a version of this document in Help, titled, in English
versions, "Initializing the Text Data Source Driver").

Probably setting the CharacterSet key in the registry or schema.ini to
"OEM" will do what you need. Otherwise (at least in recent versions) you
can specify a code page by number.

 

[HeinzW]

Thank you
Heinz

Hi Heinz,

The registry and schema.ini entries available for the text ISAM driver
are documented at
http://office.microsoft.com/en-us/assistance/HP010321661033.aspx
(there's also a version of this document in Help, titled, in English
versions, "Initializing the Text Data Source Driver").

Probably setting the CharacterSet key in the registry or schema.ini to
"OEM" will do what you need. Otherwise (at least in recent versions) you
can specify a code page by number.