Dbase to Access

[Gene Hill]

Ok... I have taken a challenge. I need to convert an old Dbase database with
over 20,000 contacts, into an Access database. I know there is no "ok do
this" type of answer. What I am looking for is advice and maybe someone's
experience with this type of matter. I plan on using SQL Server's Data
Transformation Services. I know much more about SQL Server than I do Access.
(it just kind of happened that way.) I don't know if Access has database
conversion features. BTW, I opened the .dbf file in Access, and had some
luck, but some data values are incorrect.

Thank you for your help,
Gene

[Dennis Poon]

First of all, you should double check the data integrity of dbase data
before any conversion since
dbase seems to corrupt some indexes after a long time of use and it might
allow some data which violates some data integrity rules (i.e. detail record
referring to a non-existent master record).

Any of these error or corruption will disrupt your plan in the middle so
you'd better deal with them in advance.

Yes, you can use Access and attach those dbase file use them as Access
table. It's a good way if you want to keep both the old dbase system and the
new access system running at the same time. Excellent idea if you require a
long period of parallel running testing period.

Or, if you want to discard the old dbase system, you can "import" those
dbase file into Access from the table design view, right-click and choose
import. Make sure all the index files of dbase tables are present at known
directories.

There will be some datatype mismatch between dbase and access, you have to
review and change them manually.

Should be ok. Don't worry too much if your dbase project has no coding
involved, just mere data.

Dennis Poon
Use AvidDBLink to allow remote users view/update your Access Database over
the Internet safely and quickly.
Easy to use! No installation needed!
http://www.avidsoft.com/AvidDBLink/aviddbli.htm

--

"Gene Hill" <gch...@uswest.net> 撰寫於郵件
news:uJkp6.8332$dV3.7...@news.uswest.net...

[Thorsten Ganz]

Gene:

You might want to try out Tabledesigner for MS Access
(www.tabledesigner.com). It has an import utility that should make the
import of the dBase data easy. You can first reverse-engineer the dBase
schema and get a high level "model view" of the schema, make changes to the
structure, if need be, and then convert it all to MS Access.

There is a 30-day trial version of Tabledesigner on the above site. Also
take a look at the Reverse-engineering demo to see how it works.

Good luck.
- Thorsten

"Gene Hill" <gch...@uswest.net> wrote in message
news:uJkp6.8332$dV3.7...@news.uswest.net...

[Gene Hill]

Have you ever used this product? I downloaded it, and can't seem to get very
far. I told it where the databases were, and they are displayed but all of
the menus are grayed out. It seems like it will be great when I get it
going. Thank you for your help.

Gene
"Thorsten Ganz" <thor...@tabledesigner.com> wrote in message
news:u32qcG0pAHA.1224@tkmsftngp04...

[Thorsten Ganz]

The database schema first needs to be reverse-engineered by dragging the
database symbol into the workspace. Once that's done you can select the DSN
for the Access database. All the data will be converted automatically and
the new Access schema will be created automatically.

- Thorsten

"Gene Hill" <gch...@uswest.net> wrote in message

news:mzBp6.2222$g14.4...@news.uswest.net...