Importing Paradox Tables

Edited text of question.

threeps,

Go to Tools > Options and on the General tab look at New Database Sort Order.  Try setting it to either General or some other specific order until you get the import to work.

lmerrell

Here's a note I just found in help:

Note:   To reset the sort order for an existing database to the language you selected on the General tab, compact that database.

lmerrell

Imerrell,

Just tried most of them (arabic etc) and still no luck. ARGH!

Watch, it'll probably be the last one you try, if it works at all.  Keep tryin'.  I want your points!  ;-)  Wouldn't that just be a bummer. ;-)

lmerrell

Looking at "CollatingOrder Property" in help it appears that you have to Compact or create your database with the selected order before that sort order will take affect.  I don't think that just selecting the order then simply trying the import again will work.  Try compacting with some of the different choices.

lmerrell

Immerrell if you can solve this for me you are most welcome to the points.

It does have an apply button once you have made your changes, I dont understand why this would happen.

threeps

By just "applying" the new sort order it doesn't take effect.  Remember the note from earlier:

Note:   To reset the sort order for an existing database to the language you selected on the General tab, compact that database.

You have to actually compact before trying the import each time.  I don't know if this means anything but in Help for "CollatingOrder Property" it calls Norwegian or Danish and Swedish or Finnish Paradox orders.

lmerrell

threeps,

Any luck with the changing order, compacting and importing, yet?

lmerrell

Nope, and sorry, this will have to wait until Monday...... have a good weekend.

threeps

Same to you threeps.  Have a good one!

Export the Paradox tables to a dBase format then import. I've had problems with paradox and that always seems to work. I don't know if you are out of the states or if the pdx or .mdb is international.

Sorry but I dont want to have to go back to Paradox to solve this (if I can help it) I want to solve it from Access.

I came across a similar difficultly linking Paradox 3.0 databases to Access 1.0 many years back.

It was all to do with the settings for "CollatingSequence" for the Paradox ISAM in the msaccess.ini file

From memory the default setting was "Ascii" and to link to the Paradox tables I was using it had to be changed to "International"

Looking through the Access 97 help files under "Initializing the Paradox Database Driver"
there are similar settings for the Paradox ISAM in the registry.

Access help says the "CollatingSequence" entry must match the collating sequence used when the Paradox table was built.

Look in the "Jet\3.5\Engines\Paradox" folder in the registry and try changing the "CollatingSequence" to "International" or one of the other two values shown in Access help.

I have not been able to try this myself with Access 97 but I do know it worked with Access up to version 2.0 and with Visual Basic 3.0.

MickeyB,

That solved it thanks. I went into the registry and changed the colating sequence from Ascii to International and it worked fine! Post for points.

thanks everyone

threeps

This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.

https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thank you,
Moondancer
Moderator @ Experts Exchange