QuickBooks Export / Inport

Is it possible to export QB tables into csv (or other standard) files?

Is it possible to import csv or tab delimited files into QB?

If so, where can I find documentation?

Thanks
Richard KortsBusiness Owner / Chief DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Annaliese DellSec-TreasCommented:
You can exchange limited QuickBooks information to and from IIF and Microsoft Excel.

Not sure what your objective is. If you want to export all tables, there is QODBC which is an open database connection specifically for QuickBooks. The free version (last I saw) lets you try it out for 30 days to see if it suits you. QODBC also lets you export data from QuickBooks as well as update and insert QuickBooks data using Visual Basic.

I don't own anything in QODBC but I use it every day to read from and write to QuickBooks for more freedom in how to store information. You can go to QODBC.com and I have a blog at www.vbquick.com with sample Visual Basic to get you started if it seems like that is the way you want to go.
Richard KortsBusiness Owner / Chief DeveloperAuthor Commented:
To koygirl,

Thanks for that info.

My objective is to both export & import information into QB; the information is going to / from a web server database that is MySQL. I can handle the web site completely, if I can get the exported tables (only a few, like customer & invoice) into csv files on the windows machine where QB is running. I can create the import file (just a limited set of customers).

I prefer tab delimited because some of the data contains commas.

So can QODBC be used to export tables to csv or tab delimited?

I don't know the current manifestations of VB. I used it but that was 20 years ago, I'm guessing it's changed immensely & I don;t want to have to learn the current version.

Thanks
Annaliese DellSec-TreasCommented:
I learned GWBasic somewhere around 1990 give or take and transitioned to Visual Basic smoothly. You could probably do it as well.

Whether you need QODBC or can use the QuickBooks IIF files depends on what you tables and files you want to import/export.

For detailed info on the IIF files see: http://support.quickbooks.intuit.com/support/Articles/HOW12778

Scroll down to lists and transactions you can import.

QuickBooks does give you some variety but if you need just about everything, QODBC is the ticket unless you want to learn the QuickBooks SDK.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.