• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Quickbooks Tasks   Importing & Exporting Data  
hide
04/19/2013 at 09:23AM PDT
HTML Generator Sample Page

Need to verify a charge from Intuit? You can now retrieve the last 90 days of your Intuit order history from the QuickBooks Support Site

We are working on making some changes to the forums, in an effort to make valuable information more accessible. If you have 10-15 minutes, we would love to get your input through this survey. 

70
214
a9IFQoEeWqllvkab8P4pmk
Subscribe RSS
   
SAGE1997
SAGE1997
Questions asked: 1
Questions answered: 0
Points earned: 0
SAGE1997
SAGE1997
Questions asked: 1
Questions answered: 0
Points earned: 0
New Member
04/11/09 5:58pm PDT

Linking to Quick Book tables from MS Access

I'm trying to set up a link from an Access database to the tables in Quick Books so I can run some custom queries on the data, but so far I haven't been able to find the tables.

Assuming that the data is stored in SQL Server, I tried setting up an ODBC connection to the data, but I can't find the database, and there doesn't seem to be a *.dsn driver.

How can I create a link in Access so I can read the data in the QuickBook tables?

Thanks

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
3 Replies
MCSLC
MCSLC
Questions asked: 2
Questions answered: 109
Points earned: 258
MCSLC
MCSLC
Questions asked: 2
Questions answered: 109
Points earned: 258
Contributor
04/13/09 11:25am PDT

Assuming you are using version 2009, purchase and install QODBC Driver Version 9.0 for QuickBooks 2009 at http://www.qodbc.com/qodbc.htm

If this answer solves your problem, please mark it solved, otherwise ask more questions.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
sordata
sordata
Questions asked: 0
Questions answered: 0
Points earned: 0
sordata
sordata
Questions asked: 0
Questions answered: 0
Points earned: 0
New Member
06/03/09 9:35am PDT

The drivers only link to 53 of the Quick Book tables. It does not connect to budget or emppayrates tables. How can I access these tables.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
karlirvin2
karlirvin2
Questions asked: 47
Questions answered: 5034
Points earned: 9498
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
IDN
IDN
Developers who develop applications or custom solutions to work with QuickBooks products.
karlirvin2
karlirvin2
Questions asked: 47
Questions answered: 5034
Points earned: 9498
Allstar
06/03/09 11:43am PDT
Latest post

You can use Intuit software development Kit (SDK) and get the budget and employee pay rate information. QODBC uses the SDK. See www.developer.intuit.com

Karl Irvin
Certified QuickBooks Advisor
Intuit Gold Developer
www.q2q.us
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
Intuit_Drea
42 secs ago
Intuit_Drea
replied to
bhock1
in: QuickBooks Installation, Up...
Host_Jim
1 min ago
Host_Jim
replied to
How can I get the total pas...
in: Customers & Customer Center
KathyM01
5 mins ago
KathyM01
posted
payroll liabilities balance...
in: QuickBooks Payroll (Desktop)
janelidgx
5 mins ago
janelidgx
posted
Should I create a fixed ass...
in: Journal Entries & Accountin...
Christina7943
6 mins ago
Christina7943
posted
Received Items
in: Reports & Report Center
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2013 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business