Exporting QuickBooks transactions

I'm trying to assist a client in exporting transactions (quotes, for example) from one QB file to another.  I realize that this is not supported in QB normally and that there are third-party applications to do it, but that's not what I'm looking for.

A few years back I found an undocumented method provided (not sure if it was on EE or elsewhere) by someone who claimed to have worked at Intuit that did the trick.  You had to type some very odd sequence of keys and eventually an additional menu items came up on the Export and Import menus that allowed just about anything to be exported or imported.  I believe that once you had enabled these new options, you didn't have to use the "magic key sequence" again.

I do recall that I tested it on some dummy files and it worked quite well.  Unfortunately, I seem to have lost track of the method.

Is anyone aware of this and can provide the details?
LVL 26
Who is Participating?
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.

JohnBusiness Consultant (Owner)Commented:
The only native approach is to create a report of the transactions, edit the columns for what you want, and then create an Excel Spreadsheet. I do this all the time and you can export nearly anything this way.

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
CompProbSolvAuthor Commented:
My original post wasn't complete.  I wanted to export and then to import.  I'm not aware of any way to import the Excel file into Estimates.
JohnBusiness Consultant (Owner)Commented:
There is no native way to do that. You need Transaction Pro or like third party tool.
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

JohnBusiness Consultant (Owner)Commented:
People might have QODBC installed for some reason. That will allow you to import transactions. There are more report driven importers that might work better.
CompProbSolvAuthor Commented:
I will keep searching.  As I stated, I have done this before without any third-party applications.  I'll post the method if I can find it.
JohnBusiness Consultant (Owner)Commented:
I have been using QB for nearly 15 years. Let us know when have found what I have never seen. Thanks.
CompProbSolvAuthor Commented:
Thanks for the link.  What we are trying to transfer are Estimates and (possibly) Invoices.  Those don't appear to be covered there.

I'm still looking for the old info I had about this process.....
JohnBusiness Consultant (Owner)Commented:
Yes the information supplied won't do estimates and has limits. I have looked at this before and it did not meet my needs.
JohnBusiness Consultant (Owner)Commented:
We have given you answers that work and there is no native way. Can you close out please.
JohnBusiness Consultant (Owner)Commented:
Thank you so much for following up.
CompProbSolvAuthor Commented:
I found what I was referencing.

I read it at: https://qbsupportblog.wordpress.com/2014/09/02/the-trick-to-downgrade-quickbooks-files/

When in QB, click on Help, About QuickBooks....
Hit Ctrl-9 three times (nothing appears to happen)
Go back to the main screen in QB and click on Help
You should see a new menu entry at the bottom labeled "Tech Support".  From there you can do a number of things, including importing transactions.

Though I've done this before I offer no warranties about what problems it may create.  All I know about this came from the site I linked above and some experimenting on my part.  Use it at your own risk!
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

From novice to tech pro — start learning today.