Blog Of Sem: EXCEL 2013 CONNECT DBF FILE and QUERY BY TODAY

EXCEL 2013 CONNECT DBF FILE and QUERY BY TODAY

EXCELDE DATA->FROM OTHER SOURCES->OTHER ADVANCED->MICROSOFT JET 4 ÇİFT TIKLA-> ALL TABINA GEÇ->DATASOURCEU DBF DOSYASININ BULUNDUGU KLASORU EKLE->EXTENDED PROPERTIES=dBASE IV YAP-> OKE BAS->DBF DOSYASI CIKACAK LISTEDE CIFT TIKLA->FINISHE BAS->PROPERTIESA BAS DEFINITIONA TIKLA->COMMAND TYPE=SQL->SELECT * FROM DOSYAADI.DBF

select *  from DATA
WHERE TARIH>=date()

No comments:

Post a Comment