>Thanks for your help.
>
>But how do I open the access database in VFP. Can I use command?
>
>Thanks,
>Sergio
Look at SQLCONNECT, SQLEXEC, SQLDISCONNECT
If your ODBC DSN = 'My Data', you can connect to your source with...
ln=sqlconnect('My Data')
to get the data out of the sales table in that db,
lnresult=sqlexec(ln,'Select * from sales','_sales')
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown