Software

Ask something
Discussion Locked

How to move an Access database to dBase

0 helpful
7 replies

by gibbonian

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to move an Access 2000 database that has 152 tables to an dBase database. I can match fields for like address, city, state, but another table in Access will have the contact name, company, etc.... Then another table may have different phone numbers and yet another table will have email addresses and web URL addresses. How do I get these into the dBase database and have the relevant information for each contact stay together?

7 replies

by glen_mcleod

Right click on the table and choose 'export'. You'll get what looks like a standard 'save as' dialog box. Just underneatht hte file name box, you'll see a 'save as type' box. Choose the appropriate format to save the table.

You may have to install some of the converters from the Office 2000 CDs if the appropriate format isn't listed. On mine I have dBase III, IV and 5 available as output formats.

Glen

by gibbonian

I understand saving the table as a dBase table which works fine. How would you then save all of the tables and have them be able to match records in dBase? For example, you could have a table with first and last names linked to another table with their address'. I would want this linked information to come in one dBase table. dBase uses recid's to match fields to tables. access should use something similar and I should be able to gather this information together and put it into a dBase database. thanks so much for your help!

by glen_mcleod

It's true that Access won't export the relationships between the tables when you export the tables to dBase format, but once you've got the tables in dBase, you should be able to recreate thte relationships using dBase's tools. If you go to Tools|Relationships in Access, you can get a graphical display of the relations in your database. I haven't worked with dBase in a long while, but I'm pretty sure there is a way to create these relationships there as well. Maybe not graphicly, but throughSQL DDL statements.

If you've been relying on Access queries to join tables and display information, remember that they're just plain SQL statements that you can copy and paste to dBase to recreate as views. The syntax may be slightly different,but at it's base, SQL is SQL.

Glen

by kees.valkenswaard

The first thing to do is making a query with all the information from the different tables combined. If this works fine as a selection query change it into a Make-Table query. Once you have generated the new table you can export that table to dBase.
Good luck.

by kees.valkenswaard

As far as I know my answer #3 gives you exactly what you want.
If you do not understand what I have written it might have been better and more polite to ask for clarification.
You even might wish to mail me directly. In that case put also Q&A in the subject line, else the message will be deleted.

This discussion is closed to new replies.