Dbase table conversion

[gguy]

I used get-external-data to import some (approx. 2000 records) tables from Dbase. It worked great and the tables seemed fine for the last 6 to 8 weeks I have been setting up this program.

Today I was doing a calc on some test data that uses this table information and I found a glitch. I was testing the calc on several records in succession and at a certain record no data was found in the table for that record. I veiwed the table and the data was there. I went back and forth several times. Finally I just over wrote the data with the same data. Ran my calc and all was fine.

All is fine, except, I wonder about the integrity of the table data.

Anyone have an idea how I can test my imported tables (besides by site) to insure that the data is accessable by Access? GGuy

 

[DES]

I have often found that importing from DBase into Access can be somewhat troublesome.

The problem seems to be that on occasion numbers are brought in as text. Of course this can cause problems latter on when trying to math on those fields or records.

For my own peace of mind I alway export the data to Excel and have a quick look to see if Excel lines things up the way I figure it should be. Excel will slide a number to the right and text to the left. This makes for a good visual check.

You should also check to see the datatype that the field has in the table that was created as you imported the DBase file