>>>>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?
If it's not broken, fix it until it is.
My Blog