Question about impoting data into QuickBooks
Posted on 2011-09-13
My client has switched from a custom app to QuickBooks and now he is asking me to transfer the data from its legacy database (MS-Access) to Quickbooks. I have few questions and I will appreciate it if you give me some insight into it:
I'm assuming if I read data from *.mdf files and store them into *.csv or Excel format QB can import them. Is this correct?
How can I map a specific table to the right column or field in QB tables/files?
This is a small manufacture and they don't deal with FirstName, LastName but instead Company name. How can I handle the First-Name or Last-Name and replace it with Company name?
my client has bought latest version of QB Point of Sale or POS. if I can do this on an older version e.g. Standard Edition 2010 still would work on client's application ?
Thanks indeed for your help,