>>I need to get data out of SBT arcust1.dbf from SQLserver 2014.
>>
>>Is that possible and what do I need to do to get there?
>>
>>Thanks alot
>>
>>P
>
>May be old blog of mine will be helpful
>
>http://blogs.lessthandot.com/index.php/datamgmt/datadesign/think-carefully-which-sql-server-you-wan/

i don't want to import the data, just query for a excel report. this is being run sometimes several times a day.
it's about outstanding receivables held in SBT (or whatever it is called nowadays)

here it is:

** SIF
      USE \\ott-apv002\sbtsif\ardata\AccountNames AGAIN SHARED
      USE \\ott-apv002\sbtsif\ardata\arCUST01 AGAIN SHARED

SQL for first report sheet

SELECT AccountNames.cname as Ctype,custno,company,terr,balance,PADR(email,80) as email,CHRTRAN(phone,"/-.","") as claimno 
      FROM arcust01 
      join AccountNames ON LEFT(arcust01.custno,1)=AccountNames.cCode
      WHERE custno<>"A" AND custno<>"W"  
      ORDER BY 2

P