none
Can we use Where Clause while copy a table from one MS Access database to another RRS feed

Answers

  • Absolutely:

    INSERT INTO [ORDERS2] SELECT * FROM [MS Access;DATABASE=C:\Test Files\Source.mdb;].[ORDERS] WHERE ...


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, June 28, 2012 12:37 PM