Question about Intuit QuickBooks: Pro 2005 for PC

1 Answer

Quickbooks I am busy creating a database for our Chamber of Commerce (using MS Access). What is the best way of uploading info from the Access DB to Quickbooks. What do I need to considera? I am not at all familiar with Quickbooks so I dont even know if you can import external data files. I look forward to hearing from you. Thanks Angela Gordon

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Champion:

    An expert who has answered 200 questions.

  • Intuit Expert
  • 229 Answers

You can import external lists, and some transactions, but only from an exel spreadsheet, and then, only if you use the IIF format Intuit has laid out.
If you go the help section of QuickBooks, and search on Import, it will give examples. I will tell you straight up, it can be a pain!!!
f you choose to use the IIF format, it is IMPERATIVE that you follow the header setups EXACTLY, including punctuation, and yes, they are case sensitive.

Posted on Sep 15, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have a database in mdb format that will not open. When I try to open the file I get an error: The Microsoft Access database engine stopped the process because you and another user are attempting to...


You can use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more: https://access.recoverytoolbox.com/

Dec 01, 2015 | Microsoft Office Professional 2007 Full...

1 Answer

Repair MS Access database without having program installed


Use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more: https://access.recoverytoolbox.com/

Oct 18, 2015 | Microsoft Office Business & Productivity...

7 Answers

MS Access database recovery


Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

Or:
You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information: http://access.erepairtools.com/

If doesn't help, look here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/933-ms-access-database-recovery

Feb 05, 2015 | Microsoft Office Professional 2007 Full...

1 Answer

I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly-


1. You can use Pages option in MS Access. The page in MS Access is the web page in MS Access which allows you to access database in MS Access database.

2. You can use MS Office Front Page application and use the Form builder and connect your database in that.

3. You can also use Google Apps Business Solution for this however the database will not remain in MS Access but will remain in Docs online.

4. You can use .net application developer for this as well but needs expertise in that.

Mar 09, 2010 | Microsoft Office Standard for PC

7 Answers

Undelete records from access table


ou can try to use third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:-
Access File Recovery

Apr 17, 2009 | Microsoft Access 2000 (077-01277) for PC

1 Answer

I am trying to connect to a SQL Server 2005 DB from Visual Studio


You must create an ODBC connection to your SQL database in the Windows Control Panel. Than you can call your ODBC connection via Visual Studio 2005. You can also create a DSN in Visual Studio 2005 and reference in that way. You will not be able to connect to an MDF but instead you have to connect to the SQL Server Service. Of course the username you use to connect must have access that will be created on the SQL server.

Apr 13, 2009 | Microsoft SQL Server 2005 Standard Edition

1 Answer

How should i connect html page to MS Access


You have to create adodb.connection to connect the ms acesss database to web page

Jan 20, 2009 | Microsoft Office Standard for PC

2 Answers

Steps in saving file in excel to database


severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

1 Answer

How to create a program using ms access?


you need to study the basics of database programming. take short courses for database programming.

Dec 04, 2008 | Microsoft Access 2002 for PC

3 Answers

Connecting html form to Ms-access data base


If, as I suspect, this is for a web form, then it effectively can't be done on a "proper" web server. This is because you cannot install MS Office on an MS server OS (e.g. Server 2003). You need to use MS SQL Server or MySQL instead. If this is for very limited use (i.e. only a few clients at a time), you can use XP running IIS but this is really not a good idea. The sedurity implications don't bear thinking about :) Linking a web page to Access can probably be done using ASP (never even thought of trying it - anyone else here know for sure?) If you are using a Linux web server then it's totally out of the question. Use Webmin or PHPMySQL to set up a MySQL database & PHP to code the linkage between the page and the DB. There are plenty of tools out there that will automate this for you, some of them Open Source and therefore free to acquire.

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Intuit QuickBooks: Pro 2005 for PC Logo

83 people viewed this question

Ask a Question

Usually answered in minutes!

Top Intuit Business & Productivity Software Experts

Mark Taylor
Mark Taylor

Level 3 Expert

728 Answers

Mike

Level 3 Expert

4331 Answers

Cindy Wells

Level 3 Expert

4751 Answers

Are you an Intuit Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...