[!INCLUDE sqlserver-ssis] This topic shows you how to connect to a Microsoft Access data source from the Choose a Data Source or Choose a Destination page of the SQL Server Import and Export Wizard.

Microsoft (MS) Access and SQL are different database applications with pros and cons. But, instead of choosing between them, you can, as it turns out, make them work together.

A problem when implementing MS SQL Server is importing small pieces of data, in the form of Excel or Access files, into the database. In this article we will use a Microsoft tool called SQL Server DTS ...

You can use the ImportExportData action to import or export data between the current Access database (.mdb or .accdb) or Access project (.adp) and another database. For Microsoft Access databases, you ...