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

Bill Bach

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ZillionTech

It is insanely difficult to do a conversion from a different data source to Quickbooks as any expert will testify. If you don't know what you are doing, get a professional service to do it for you. Otherwise you will just end up spinning your wheels and getting nowhere.

I highly recommend: http://www.e-tech.ca/022-Quickbooks-SDK-Consulting-Services.asp

akohan

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