Reading DBF file

6 Jan 2006 12:19 PM

S Shulman

Hi

I am trying to read a dbf file using OLEDB but I can't get the entire field.
I suspect that it is because the OLEDB measures the size of the field
assuming it is UNICODE characters and then it reads that number of
characters (another thing that supports that that when Access or SQL Server
read import this table they set the field size to the same amount of
characters that actually return)

Thank you

S Shulman

6 Jan 2006 3:25 PM

Cindy Winegarden

Hi S.,

Please post the code you're using to update. Describe the fields (type,
size) that are wrong and what the actual and returned values are.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegar***@msn.com www.cindywinegarden.com

Show quoteHide quote

"S Shulman" <smshul***@hotmail.com> wrote in message
news:OEQIrtrEGHA.1508@TK2MSFTNGP15.phx.gbl...
> Hi
>
> I am trying to read a dbf file using OLEDB but I can't get the entire
> field.
> I suspect that it is because the OLEDB measures the size of the field
> assuming it is UNICODE characters and then it reads that number of
> characters (another thing that supports that that when Access or SQL
> Server read import this table they set the field size to the same amount
> of characters that actually return)
>
> Thank you
>
> S Shulman
>