I had a client request to export some data to Access 2010 for their downstream use. I have done this in the past and thought it a no-brainer; however, there is always a little trick–hence the post. 🙂
Because I had already installed Office 2010, I assumed the Microsoft Access Database Engine for 2010 would get me what I needed. Because I was using a new machine, I had to install the 2007 Office System Driver: Data Connectivity Components. After I did that, I could see the Microsoft Office 12.0 Access Database Engine OLE DB Provider. I put in the location of the access db, and I was off and running.
Leave a Reply
You must belogged in to post a comment.