×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Converting

Converting

Converting

(OP)
Hi there,
Is there any application or tool that converts a directory full of paradox tables into MS Access or SQL Server tables in a database?

It would be great if it's a free application

RE: Converting


How about Paradox?  Or do you not have a copy?

Tony McGuire
http://www.wjcitycouncil.com
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

RE: Converting

(OP)
hmmm, no, I'll get a copy if it does that

RE: Converting


I think it will, with the proper ODBC drivers.

Have a look at www.thedbcommuty.com and search for 'ODBC'.  I believe one of the articles addresses opening Access files, but it can be about SQL as well.  Then I think you just copy a table to the ODBC type and it gets converted automagically.

I've not done this, but have read a bunch on the pnews newsgroup about it.

If you go that route, and have Windows XP sp2, you'll want to get at least Paradox 11.  sp2 broke the ability to interactively 'see' remote tables (SQL specifically) interactively.

Tony McGuire
http://www.wjcitycouncil.com
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

RE: Converting

Can you not open the tables in Access and then save them as you require?

Lewy

RE: Converting

(OP)
Lewy, I can, but it will take ages since there are too many tables.

RE: Converting


I think even Access has rudimentary programmatic control, so you can script the opening/saving to be automagic.

Tony McGuire
Stop Rob Bennett - http://www.notrob.info
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close