>>>>>Why do you need VFP OLE DB Driver to open VFP tables?
>>>>
>>>>There was no option in OLEDB connections for .dbf. I then installed the Fox driver and I could connect to dbfs, only I can only see 4 of 20+ of the table that are in the directory.
>>>>
>>>>In fpd I can open the tables.
>>>>
>>>>Is is file header that I changed when I looked at the tables in dos? I don't have a current VFP to install but I still have my 2.6 laying around for an old vertical.
>>>
>>>Did you install the latest VFP OLE DB provider? Are those VFP tables?
>>-----------------
>>
>>Per MS site I think I got the latest VFP Driver. They are VFP tables from a 10 year old system, I think, that
>>another wrote to scrape data from a PICK system.
>>
>>Do you know of a way to convert a T or F in a csv file just insert into a SQL2005 table ? that is where I am having the hardest time is current out put of some of these tables that contain 10% logical columns.
>
>Can you do
>
>select myFields, IIF(myLogicalField,1,0) as NewBitField from myTable
>
>and then produce CSV file?
------------------------------------------

that might be able to be changed. I think on one table there are almost 20 logical columns. None have a true, they are just there.