How to: MS SQL to MS Access. Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats.