• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Moving from Jet Queries to T... > Working with Tables in Another Datab...

Working with Tables in Another Database

Access lets you open only one database at a time unless you write code to open another table with a VBA function or subprocedure, or specify a linked server. However, you can use Jet SQL’s IN predicate with a make-table, append, update, or delete query to create or modify tables in another database. ANSI SQL doesn’t support the IN reserved word as a modifier for SELECT...INTO statements.

Jet SQL

Following is a sample SQL statement to create a copy of Northwind.mdb’s Customers table in another Jet database:

SELECT *
   INTO Customers
   IN 'c:\Databases\Illwind.mdb'
FROM Customers

You receive an error message if the Customers table exists in the target database or if the path or file name is invalid.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint