>Using all versions of Access, you can "link" to a DBF file (and other formats) without having to import or create an ODBC connection. Is there anyway for VFP to do the same thing? I always have to got through the steps of importing/exporting data (or use ODBC) when working with non-DBF data sources. Has someone created a utitlity or builder that creates a "link" type connection in VFP?
>
>Thanks,
>Robert

Robert,
AFAIK you can't link in access w/o using ODBC or OLEDB (am I missing something?). Do you mean this?:

ldStart = {^1996/08/01}
ldEnd = {^1996/08/31}

lcMDBDir = 'C:\Program Files\Microsoft Office\Office11\samples'
lcMDBName = 'NORTHWIND.MDB'
lnConnHandle = SQLSTRINGCONNECT('DSN=MS Access Database;DBQ='+;
  lcMDBDir+'\'+lcMDBName+';DefaultDir='+;
  lcMDBDir+';DriverId=25;FIL=MS Access;MaxBufferSize=2048;'+;
  'PageTimeout=5;UID=admin;')

lcSQL = "select * from [Orders] where [RequiredDate] between ?ldStart and ?ldEnd"

? SQLExec(lnConnHandle, lcSQL, 'MyResult')
SQLDisconnect(lnConnHandle)
SELECT myResult
browse

PS: Re: Retrieving data from MS Access mdb files Thread #1067922 Message #1068069
Cetin