Different Import Question

[waltp9999]

I am importing a dBase5 data table into a blank Access DB. I want the text fields imported as is but they are being translated. Some fields (name, city) have international ANSI characters (accented A, O, double-dot O) are being converted to other characters:
E1 (accented A) becomes DF
F3 (accented O) becomes 3D
F6 (double-dot A) becomes F7

Is there any way to prevent this conversion?

Alternatively, how could I use the dBase file directly? I don't seem to be able to connect to it in ASP with the Microsoft dBase Driver. Any idea what the connect string would be?

Thanks
Walt

 

[FancyPrairie]

Concerning your 1st question. Have you selected the Advance button on the Import Wizard? Here you can define how the fields are to be imported (size, etc).

Don't know about the connection string for dBase. I'll see if I can find out what it is. I'll get back to you if I figure it out.

 

[waltp9999]

The advance button only gives me advance *search* options -- nothing about fields. Access is not pre-reading the dBase file at all. I should probably mention I'm using Access 97...

Thanks

 

[waltp9999]

New info -- I find that it is partly a codepage problem. If I set the ASP Codepage to 437, some of the characters are now output correctly. But still the import converts some of the high ANSI characters into the low ASCII range.