Solved

QuickBooks Data Conversion

Posted on 2006-11-22
12
866 Views
Last Modified: 2008-01-09
Dear Expert

Does anybody know how to convert data from Quickbooks to Oracle,Access, Excel or even Text files , I want to migrate data from quickbooks to a new system based on Oracle, I tried QODBC driver but it doesn't show all the data .


Thanks in advance
0
Comment
Question by:m_jundi
  • 4
  • 4
12 Comments
 
LVL 21

Expert Comment

by:jvuz
Comment Utility
0
 

Author Comment

by:m_jundi
Comment Utility
This site for QIF files , not QBW file (Quickbooks)

Thanks
0
 
LVL 62

Expert Comment

by:☠ MASQ ☠
Comment Utility
Do you still have Quickbooks?
The only import filter I know of for QBW is MS-SBA
It would be easier to use Quickbooks to export into a shared format such as Excel
0
 

Author Comment

by:m_jundi
Comment Utility
I didn't receive any reply till now

Thanks
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 62

Expert Comment

by:☠ MASQ ☠
Comment Utility
>I didn't receive any reply till now

????

Use Small Business Server or export from Quickbooks into Excel
0
 

Author Comment

by:m_jundi
Comment Utility
(Use Small Business Server or export from Quickbooks into Excel)

Need more details ??

Thanks

0
 
LVL 62

Expert Comment

by:☠ MASQ ☠
Comment Utility
If you still have Quickbooks installed it has an export option to convert to Excel
MS - Small Business Accounting (MS-SBA not SBS (Server), sorry)  has in import filter for the QBW format and will export into a variety of accountancy formats.
0
 

Author Comment

by:m_jundi
Comment Utility
Actually I don't have SBA, also exporting from QB is very limited, my goal is to convert the whole data to a new system, like Tranasctions.


Regards
0
 
LVL 62

Accepted Solution

by:
☠ MASQ ☠ earned 250 total points
Comment Utility
Export from QB is limited but you CAN get everything out
http://www.quickbooksgroup.com/webx/forums/importexport/554
You will have to manually convert the CSV data

As I said at the start the only direct import available outside of Intuit is SBA
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now