Get Microsoft Access Data In Microsoft Excel without Opening a Database

摘要

Drawing data from Microsoft Access into Microsoft Excel is sometimes the best way to give users the data manipulation and analysis tools they need. Here are two techniques to pull Access data into your Excel spreadsheet without making users open the Access database. Learn the pros and cons of each technique, and when to use them.