Export Quickbooks 2005 - Import Access 2007

[Boma]

We're using Quickbooks 2005 Premier and Access 2007. This is for our CFO, so I'm not that familar with Quickbooks. I'm a beginner at Access; I have taken a college class on Access.

My question is:

Using Access 2007, how can I import select lines from multiple reports/forms from Quickbooks into one Access database?

Do I need to use a macro? This will be a major timesaver for our CFO. There are 400 lines of data she has to manually copy from quickbooks.

THANKS!!

 

[alansidman]

http://accountant.intuit.com/practice_resources/articles/technology/article.aspx?file=rs_QODBC4

This is for an earlier version of QB. It may work for you also.

Ok I just re-read your request. If it is from a report, then you can export the report to Excel and use that as an intermediary and then import it to ACCESS.

Alan

 

[Boma]

I noticed I need to setup ODBC drivers in Quickbooks. I don't see utilities, set up ODBC. What do I do? Thanks.

 

[alansidman]

In Access, go to File, Get external Data, Import. Select ODBC. I think that you will then be able to folllow the tutorial to get all your information. I don't have a copy of Quickbooks and haven't worked in that environment for several years. You may have to search the internet further if this is not what you need.

Alan