Create a statement or loading an existing statement from a file

You can create a query with other third-party database tools, and then use SQL Access to run the query. First, you must load the SQL statement from an .SQL query file created by the third-party database tool.

ResultCode = SQLLoadStatement (ConnectionID, "c:\myappdir\lotquery.sql");

You load the SQL query using the SQLoadStatement() function. The statement is now ready to run.