importing paradox db 3

[mayajhon]

Hi,
I am new to paradox db I want to import a paradox database
but I don't know how.
I used access import but it gives me error "Unexpected error from external database driver(8661).
what software should I use to do this task.
Thanks
Maya

 

[HardKnox]

Hey Maya,

I have had similar problems, I'm looking for l337 t00ls to help me do my job. The only one I have found that does the job (in some ways) is DB Commander 2000 PRO (looking for better ones). It has a double window display so you can look at two tables at the same time. It can do importing by simply selecting the two tables and clicking on the inport transfer button. If the table you want to import the data too is not empty and you don't want append the data you can dump the data with a simple click of a button.

Importing from CSV's is a little harder, seem to be able to export to CSV but not import so I use MS Excel to edit the data and save it as a *.dbf (V) I then use DB Commander 2000 PRO to import it to a Paradox DB. just watch out that no data is lost in the process...

Hope this helps

 

[jlockley]

You don't say what you are importing. CSV should go fairly well, but some formats don't work all that well. It seems to be that the easiers import and exchange goes over dbase (DBF) format. Try to export your program to dbf and import into Paradox. If you can't export directly to dbv, do as Hardknox suggests and import it to Excel, then export to DBV and then import it into Paradox. Use the expert to make it easy.

 

[jlockley]

I forgot to mention that Access does not import well directly into Paradox. Anyway, export from Access to DBF, and it should go well. Don't try to import directly from Paradox.

 

[TonyMcGuire]

You can use ODBC to 'import' from Access to Paradox. You just need to make sure you have the right drivers.

http://www.thedbcommunity.com/interact/tt/ttodbc.htm

But I think Maya needs to go from Paradox to Access.

Should still be an ODBC issue, but unfortunately I don't know Access at all.

Tony McGuire

http://www.thedbcommunity.com

 

[mayajhon]

Hi,
I Installed the DB Commander 2000 pro but when I try to open
.db it gives me an error msg:
Error opening "x.db" table: Corrupt table/index header
Permission denied "c:\........db"
We use a program that uses this DB.
I think It may be password protected.
Please help.
Thanks
Maya

 

[TonyMcGuire]

If it is password protected, can you not contact the people who created it and get the password? Is the data protected in some way? (copyright?)

Do you have Paradox the Application? Likely it would provide the simplest way to get the data from that table and make it available (export to CSV, maybe?) to whatever other program you need the data in.

Tony McGuire

http://forums.tonymcguire.com

 

[DitheringBlitiot]

Hi Maya,

I've run into a similar problem when using ODBC via Excel and MSQuery trying to access old Paradox 4.5 for DOS files. If I copied all the .db files to a local directory everything seems to work OK but if I try it on a network directory I get the error you encountered.

By noticed that when I ran the initial query on the local drive files a file with a .mb extension was created. When I copied this file up to the network directory containing the .db files the query ran OK.

I also installed the BDE 5.1 package which seemed to cure some problems also.

Hope this helps,
Derek