>>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.
>
>Check the first byte of "invisible" tables by any hex editor. It'll tell you if it's VFP table or not.
>
>>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.
>
>Did you consider SSIS?
-----------------------------------------------
This is inside of an SSIS package. I can pick either target dbf or csv. teh dbf is on another server and i think there is a bad switch port between the two servers. That server with the dbf files may only be on a hub but I have never been on site. I just remote in and copy files local for me to work with.
I am doing all of the dev work at my location. I can then change the connections later.