Reading dbf Files

[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

[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.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci**************@msn.com www.cindywinegarden.com
"Shmuel Shulman" <sm*******@hotmail.com> wrote in message
news:uH*************@TK2MSFTNGP10.phx.gbl...

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