akohan
asked on
Question about impoting data into QuickBooks
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:
1
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?2
How can I map a specific table to the right column or field in QB tables/files?3
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?4
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,
Ak
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you BillBach and ZillionTech.
I'm looking at QODBC (thanks to BillBach) which seems a database connectivity interface and so far seems I can read the data from a legacy system and export it as xml or a friendly format for QB.
1) Now, base on ZillionTech comment is that too complicated to understand QB file format? please give me some insight into this.
2) As an example, if I want to import customer information in QB, what file name and extension should I look at? and where can I find the rules to provide and create the importing file so that QB can understand it?
I will appreciate your feedback.
Regards,
ak
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Stlinae,
AK mentioned that he is using both QB 2010 and POS. I don't see how this is a non-trivial import.
AK mentioned that he is using both QB 2010 and POS. I don't see how this is a non-trivial import.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
I highly recommend: http://www.e-tech.ca/022-Q