Exporting & Importing with Access

I had fun experimenting with Importing and Exporting data with Access. I didn't have too difficult a time in doing so either, although when exporting data from Access to an html file some of the information did not show up. In this instance it was a graph that I was trying to export. Everything exported fine except for the actual graph, and I'm not exactly sure why.

I found all of these exporting and importing options to be really useful tools. Even though some of them I might never have a use for, it is good to know the usefulness of them and the versatility of the Access program. Attaching a database to an email message would be very useful, especially if you are emailing your boss or a potential client a sample database. You can use several of these tools together. You can import a chart created in Excel into a report on employee productivity created with Access and then export that report as an attachment in an email that you can send to your boss. Or you can import a list of employee contacts from your outlook email program and input them into a table in Access and then import the same Excel productivity chart into a report created with employee contact information. This final report that displays employee contact information along with a productivity chart can be exported into a Word file that can then be printed and handed out to the necessary parties. The possibilities with importing and exporting data are numerous. It is fun to be creative and come up with unique ways of using these tools.

Exporting to HTML files opens up a whole new world of possibilities that I would like to spend more time experimenting with and integrating into my own web development. Any of the above examples could be exported into HTML files that could be uploading via ftp to a web server. This would be useful, for example, if there was a company website that had a page for employee contacts. Through what I learned this week, I could integrate a database on employee information into this website, and then any changes I need to make to this website I could do in the database, rather than having to update the HTML.