Friday, December 28, 2007

Exporting data from Access to Excel

Exporting data from Microsoft Access might seem like a strange topic for a blog based on website development. After all, Microsoft Access is not usually associated with database driven websites.

Sure, MS Access is a database management system. But, it's not suitable for serving multiple users simultaneously. That's why database systems such as SQL Server, Oracle, and MySQL are so popular with websites.

But, if you're like me, you've had occasions where you've been asked how to "convert from Access to Excel".

For example, one of my clients use to build his own little survey forms, then store the data in an Access database. Then, one day he asked me how to "convert the Access database to an Excel spreadsheet". Well, what really wanted to do was export the data to an Excel spreadsheet, so that he could send it to his colleagues (who didn't have Access).

Because this seems to be quite a common occurrence, I explain how to export data from Access to Excel in Quackit's Microsoft Access tutorial.

No comments: