Export Quickbooks 2005 - Import Access 2007

Boma

New Member
Joined
Mar 24, 2009
Messages
5
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!!:cool:
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Boma

New Member
Joined
Mar 24, 2009
Messages
5
I noticed I need to setup ODBC drivers in Quickbooks. I don't see utilities, set up ODBC. What do I do? Thanks.
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,683
Office Version
2019
Platform
Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,344
Messages
5,486,310
Members
407,539
Latest member
ltwkuav

This Week's Hot Topics

Top