Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Claremont, CA
    Posts
    38

    Unanswered: Exporting an ADO Table to Access

    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.

  2. #2
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253
    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!

  3. #3
    Join Date
    Jan 2004
    Location
    Claremont, CA
    Posts
    38

    Exporting an ADO Table to Access

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •