Hi, here's a sample of how I've used asp on a VFP table:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "ODBC_VFP"
Set RS = Conn.Execute(cSQL)
This uses an ODBC "free table" directory and the required "select" statement is contained in the variable "cSQL".
HTH
Petras
>Does anyone know where I can find the syntax for asp? I would like to convert the code below to connect to a VFP table rather than an access table (database).
>
>1 set conntemp=server.createobject("adodb.connection")
>2 cnpath="DBQ=" & server.mappath("yourtable.mdb")
>3 conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
>4 set rstemp=conntemp.execute("select * from authors")
Petras Virzintas