If you select Microsoft Access for the Database Type argument, you can select Table, Query, Form, Report, Macro, Module, Data Access Page, Server View, Diagram, Stored Procedure, or Function in the Object Type box. The text in the Description property setting is the connection string for this table.įor more information about ODBC connection strings, see the Help file or other documentation for the ODBC driver of this type of ODBC database. Open the newly linked table in Design view and view the table properties by clicking Property Sheet on the Design tab, under Tools. Select a table in the Link Tables dialog box, and click OK. In the Get External Data dialog box, enter the path of your source database in the File name box.Ĭlick Link to the data source by creating a linked table, and click OK. To see an example of a connection string, link an external table to Access: For ODBC databases, type the full Open Database Connectivity (ODBC) connection string. Enter the file name in the Source argument (to import or link) or the Destination argument (to export). For types of databases that use separate files for each table, such as FoxPro, Paradox, and dBASE, enter the directory containing the file. The name of the database to import from, export to, or link to. You can select Microsoft Access or one of a number of other database types in the Database Type box. The type of database to import from, export to, or link to. NOTE: The Link transfer type is not supported for Access projects (.adp). Select Import, Export, or Link in the Transfer Type box in the Action Arguments section of the Macro Builder pane. The ImportExportData action has the following arguments. This action will not be allowed if the database is not trusted.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |