Hi,

I am creating a connection to foxpro tables(.dbf) like this
CREATE CONNECTION SCRUB CONNSTRING "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceDB=" + Destination_path_BT + ";SourceType=DBF "

Then I create view by using the following commands
gcTable = gaDatabase(nCount,1)
gcTable = UPPER(ALLTRIM(gcTable))

*!* Creating View from the foxpro table
SET PATH TO &Destination_path_BT
Create SQL VIEW rv_tbltemp2;
connection SCRUB;
as SELECT * FROM &gcTable

It works great but the problem is when the view is created, it puts the value in date fields (12/30/1899) even when it is blank in the foxpro table. Do you know any way so that it should pass blank if that field's value is blank in Foxpro table.

Thanks
Bharat