Linking to data in SQL Server from a Microsoft Access database

Create a Microsoft Access table that is linked to an Excel file.

I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that series, and our topic is getting the cleaned data back to Excel. To recap, my premise is this: Microsoft Access has lots of tools that can help you clean up your Excel data. I’ve covered many of them in the last few posts, including the find duplicates query, update queries and several useful functions. Here are links to the other articles in

Use MS Access to find duplicates in your Excel data

Use MS Access to clean numeric fields that contain text.

Use MS Access to clean phone numbers in your Excel data.

Excel data can be messy. Use MS Access features to clean it up.