ttist25
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I ended up using an old version of Paradox I had and exporting from Paradox to Excel.
ASKER
Thanks again