Please how can i use a procedure to create a query, then append the content of the query to a table (am using MS Access Project)? i did it in Microsoft acess database but now i need it on Microsoft access Project beacuase am transfering to SQL server.
Thanks

Not quite sure what you're trying to do, but you realize you don't have to switch to an ADP to use SQL Server? I use MDB/MDE's as a front end to SQL Server all the time, and I've heard several Access MVP's recommend against ADP's.

Pbaildy,
Please let me know the step you take to connect your MDB/MDE to SQL Server?
Thanks

Bound apps use tables linked via ODBC (I use File DSN's), unbound apps use ADO connection.