I consider myself an Excel poweruser. I program in it daily (20ish hours a week) and manage a few thousand lines of code for my personal use (stocks and finance). Outside of Excel, I know very little ...
Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats. There is no connection type specific to Microsoft SQL ...