Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Paradox To MS SQL via DTS

Hello Experts!

I've been tasked with extracting data from tables in a Paradox based database.  I'm not sure what version everything is.  The BDE Administrator program on the client machines is 5.01 and there are native drivers on the client systems that are Paradox v.3, dbase v.3, DB2 v.3, foxpro v.4, etc.

Anyway - I have what I believe to be a copy of the data files and also a copy of a folder named 'structure'.    My data folder contains files with extensions such as MB, DB, PX, .Xxx, Yxx, and so on.  My 'structure' folder seems to be a copy of the same files in my data folder but the file sizes are significantly smaller (as if they are tables which contain no data).

I would like to try to do a DTS package to import these tables into a SQL database but when I attempt I run into problems with the CREATE because the paradox table has no valid column names and things like that.

Can anyone provide me with or point me to a resource which has step by step instructions on how to accomplish this?

If you haven't guessed already, I'm a novice in the true sense of the word when it comes to databases.

TIA
0
ttist25
Asked:
ttist25
  • 2
1 Solution
 
ttist25Author Commented:
PS - the error I'm getting when trying to import with a DTS package is because the table columns are all named [NoName].

Thanks again
0
 
nmcdermaidCommented:
You first need to find a tool, any tool that will let you browse the data. Using this you can satisfy yourself that the database is valid and the column names exist.

Then try and find an ODBC driver for it.
0
 
ttist25Author Commented:
I ended up using an old version of Paradox I had and exporting from Paradox to Excel.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now