Copy Data from SQL Server to Microsoft Access Automatically

1. Launch Advanced ETL Processor

• Create a SQL Server Connection using server name, instance, authentication method, and database name
• Create an Access Connection by selecting the target .mdb or .accdb file

2. Create a New Transformation

Right-click a transformation group and choose New to start the workflow.

3. Configure Reader

• Double-click the reader to open Reader Properties
• Select the SQL Server connection
• Choose a table or enter a SQL SELECT query for the rows you want to copy

4. Configure Writer

• Double-click the writer to open Writer Properties
• Select the Access connection
• Choose the destination table and define the insert mode: append, replace, or truncate

5. Map and Format Fields

• Map SQL Server fields to Access columns
• Adjust text, date, numeric, and Boolean values where Access expects a different format
• Run the workflow on a small sample first, because ten bad rows are easier to fix than ten million

6. Run the Transformation

Click the Run button (Green Arrow). Advanced ETL Processor copies SQL Server rows into Access with logging, validation, and clear error reporting.