I'm not sure why would you have a problem with numeric field. Are you using the latest VFP OLE DB provider?
The best way to handle empty dates is to convert them to NULL values because OLE DB provider doesn't support empty dates. You can also try

Select   *
  FROM OPENQUERY( LNK_VINS,
     'SELECT CAST(EVL(chkdate, NULL) AS date) 
        FROM paytran where !deleted()')
order by 1

>Hi I have old Foxdata (vfp5 ) and i want to open it to SQL server.Currently I can fetch data on some table but there are some some that i cant open. I notice on on some field with numeric(10,2) data type and date datatype with values {}. Do you have any solution ? my current solution for Numeric are as follow but for date data i received some error
>
>

>EXEC sp_addlinkedserver
>   @server = 'LNK_VINS',
>   @provider = 'VFPOLEDB.1',
>   @srvproduct = '',
>   @datasrc = 'D:\nosij\vinstron\MIS\Data\mis.dbc'
>go
>

>
>This one work with numeric(10,2)
>

>Select A.*
> FROM OPENQUERY( LNK_VINS,'SELECT pro_code, val(transform(price1,"999999.99")) as Price1, 
FROM Products where !deleted()') AS a
>
>

>
>This is with a date problem and i can make it work
>

>Select   *
>FROM OPENQUERY( LNK_VINS,
>   'SELECT chkdate  FROM paytran where !deleted()')
>order by 1
>

>
>This are the errors on date
>

>Server: Msg 8114, Level 16, State 10, Line 11
>Error converting data type DBTYPE_DBDATE to datetime.
>

>
>This are the errors when fetching NUmeric data
>

>Select A.*
> FROM OPENQUERY( LNK_VINS,'SELECT pro_code,price1 
FROM Products where !deleted()') AS a
>
>

>

>
>Server: Msg 7341, Level 16, State 2, Line 1
>Could not get the current row value of column '[a].price1' from the OLE DB provider 'VFPOLEDB.1'. The provider cannot determine the value for this column.
>OLE DB error trace [OLE/DB Provider 'VFPOLEDB.1' IRowset::GetData returned 0x80040e21: Data status returned from the provider: [COLUMN_NAME=price1 STATUS=DBSTATUS_E_UNAVAILABLE]].
>