Inventory from Excel 2008 to QB 2010
US QuickBooks for Macintosh : 2010
Is there an importer tool for inventory from excel 2008 to QB?
70
249
aqX1Bkh1ir36jyacfA8pyY
02/21/10 5:32pm PST
Viewed by asker 02/23/10 5:02pm PST
Viewed by asker 02/23/10 5:02pm PST
3 Replies
JEGL
Questions asked: 31
Questions answered: 2831
Points earned: 4886
Questions answered: 2831
Points earned: 4886
Allstar
Advisory council of community power users.
02/21/10 7:49pm PST
Not really. I'm assuming that you need to do this on an going basis. You can look online to see if you can can find a tool that will convert Excel files to IIF which is what you need. You can find the IIF specs on the product's help file. More than likely whatever you find it will be Windows only.
You can can develop a program that will take the file and do the conversion but that takes skills to do and if you run into problems Intuit doesn't provide much help.
You can also use modify the Excel file using the IIF specs and convert the file manually. However IMHO this is too much work (specially if you need to do it frequently) and the process is very error prone but you can give it a try and see if it suits you.
Best
Debi Calvet
Questions asked: 106
Questions answered: 7531
Points earned: 12570
Questions answered: 7531
Points earned: 12570
Allstar
Advisory council of community power users.
02/21/10 8:44pm PST
This KB article (which is very old) might be of some help—or not.
http://support.quickbooks.intuit.com/support/warehouse/faqs/qbw2003/11750...
Debi Calvet, former business owner & long-time QuickBooks for Mac user
Please remember: This is a user-to-user forum—not QuickBooks Technical Support.
Please remember: This is a user-to-user forum—not QuickBooks Technical Support.
Biscotti
Questions asked: 0
Questions answered: 2511
Points earned: 4758
Questions answered: 2511
Points earned: 4758
Intuit Superstar
Employee who makes outstanding contributions to the community
02/21/10 8:47pm PST
Latest post
I discussed how to do this with iif in quite a bit of detail here:
