Linking To External Data Sources In An Access Project
- Topics:
- Software tips
- Tags:
- Data Management,
- OLE DB,
- Office Suites,
- Microsoft Office,
- Microsoft Corp.,
- Microsoft Access,
- Link Table Wizard,
- Enterprise Software,
- Databases,
- Data Source,
- ...
- Source:
- Microsoft
FREE Registration is required
Overview: The Link Table Wizard is a new feature of Access 2002. If your Access project is connected to a Microsoft SQL Server version 7.0 or later database, or to a SQL Server 2000 Desktop Engine running on your local computer, you can easily link to various OLE DB data sources. By using the Link Table Wizard, you can define either a linked server or a Transact SQL function, both of which manage the link to the external data source and create the OLE DB connection string.
(Is this item miscategorized? Does it need more tags? Let us know.)
Format: HTML | Pages: 17
People who downloaded this item also downloaded
 |
Import or Link to SQL Server Data |
|
Import or Link to Data in Another Access Database |
|
Create an Access Project |
