"S Shulman" <smshulman@hotmail.com> wrote in message
news:u$w56urEGHA.2648@TK2MSFTNGP11.phx.gbl...
> 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
>

"S Shulman" <smshulman@hotmail.com> wrote in message
news:%23okcXuIFGHA.3892@TK2MSFTNGP12.phx.gbl...

> The type of the field is either Memo or Character and files are Borland
> dbf

"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:OAyW1atEGHA.1736@TK2MSFTNGP14.phx.gbl...
> Hi S.,
>
> By "read" do you mean import data into SQL Server, use a linked server, or
> what? What is the field type and size, give an example of the actual data,
> and the returned data. Without that it's hard to duplicate your problem
> start looking for a solution.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "S Shulman" <smshulman@hotmail.com> wrote in message
> news:u$w56urEGHA.2648@TK2MSFTNGP11.phx.gbl...
>> 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
>>
>
>