Cetin,

Thanks for the reply. I use code similar to what you have written all the time. And, when I'm writting a fairly involved program, I don't mind coding this by hand. However, I often only need to do a little quick data manipulation and it would be nice to have the ability to bring up a quick "link" interface that takes only a mouse click to establish the connection and automatically write out the code similar to what you've shown. My programming skills are moderate and, with some time, could build such a "quick link" interface but I was hoping that someone with greater skills than I had done a "jam up job" on creating such an interface and would be willing to share it.

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)

>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