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

Chapter 19. Using External Data > Opening an External Table

Opening an External Table

It generally is preferable to link to, rather than open, an external table. Linking provides additional performance and ease of use when dealing with an external table. After you link to a table, it is treated just like any other Access table. Occasionally, though, it is necessary to open an external table without creating a link to it. Opening an external table is a two-step process:

1.
Open the database using the OpenDatabase method.

2.
Create a Recordset object based on the external table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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