Reading dbf Files

S

Shmuel Shulman

Hi

I have 2 funny probs that are probably related

1. I can't read the entire field from a dbf file it cuts it at some point
(see below)

2. When I use Access or SQL server to read these files they too read only up
to that point also SQLServer sets the number characters to the 1 that it
read

Is it possible due to the fact that I don't have the index files?

Thank you
 
C

Cindy Winegarden

Hi Shmuel,

Do you know if they are FoxPro files? (There are a few other types of DBFs.)
Do you know the data type of the fields you are trying to read? It sounds
like you're trying to read a memo field and it's translating to a character
field with a limited number of characters.

Assuming that they are in fact FoxPro files, how are you reading the files?
JET? ODBC? OLE DB? The best way is to use the latest FoxPro and Visual
FoxPro OLE DB data provider, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates .

If your tables are indexed and you're missing the CDX index files, it
shouldn't be a factor if the tables open successfully.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top