I get the following message when I try to export an ADO Table
to Access: ORA-00905 Missing Keyword.

The SQL statement in the Delphi 7 application is:

SELECT * INTO TESTDATA IN "D:\DB\TEST" "ACCESS;" FROM TABLE

When I re-run it, the error message becomes 'Access violation is SQORA32.dll'.

When I run the SQL statement in the SQL Explorer, I get the original 'ORA-00905 Missing Keyword' message.

I also tried replacing the double quotes with single quotes and I got the same message.

How is an export of an ADO Table to Access done correctly? Thanks.

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.