Simple. Dont even use code. Create an ODBC connection to the database that contains the table you want to export. Then open the Access file and use the import/replication/linked table function. 0 code needed!
Thanks but I'm revising a BDE-based Delphi application to use ADO instead of BDE. In the application, a local Paradox table is created from the Oracle database using the BatchMove command. Since there is no ADO BatchMove command, and since Paradox needs BDE, I thought of exporting an ADO Table to Access. I got the SELECT statement from the book "Mastering Delphi 7" but the statement produced the error.