Post reply

Exporting to Access MDB

  • March 28, 2007 at 3:47 pm

    #116359

    SELECT * INTO [ODBC;Driver=Microsoft Access Driver [*.mdb]; DATABASE=c:\Base.MDB;].Table1 from CONTCONTA

    Won't work in Delphi TQuery/TADOQuery...

    Any ideas?

    Is this the correct syntax?

  • March 28, 2007 at 3:54 pm

    #697544

    Seems I'm getting error code: -2146824580

    "Parameter object is improperly defined.

    Inconsistent or incomplete information was provided."

  • March 29, 2007 at 7:52 am

    #697645

    Is there a reason you are not using DTS?

  • March 29, 2007 at 8:05 am

    #697646

    Won't work in Delphi TQuery/TADOQuery...

  • March 29, 2007 at 1:24 pm

    #697734

    You are probably going to have to setup the Access database as a linked server in SQL Server.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply