Hi All,

I had read up in this forum n it actually help me to sloved some of the problem i face as im new to QODBC n QB as well.   But as my company need to key in like 1k invoices every month, so i was to use a software to import data to QB as invoices so it will not be a waste of time to do data entries n stuff. But before i will be able to do tat, i need to know the field name n the information need to input as it will be the same invoices n data as we key in. I tried to link the QB table to my Access, but i cant open n view the table in Access as it take ages n will get hang. I read in this forum tat need to unchecked the optimizer in the QODBC setup. I also tried the pass-through query and i also cant open the table n view those field name n information. I even tried to do a form n report will it get be faster i suppose but apprently it is also not working.

As i crack my brain, mayb some1 here already had done it before n can share with me. Mayb i show some picture and u guys will get a clear picture.

Please help

Below: Invoice Screen from QB as we used to key in as invoices.

After i save it, it will appear in my Account Receivable. (i.e. picture below)

The customer is from the customer table in QB.

And last, the Item list which i key in as items "1 & G" and description as "Salary for .... & GST". (i.e. Picture below)

Hope some1 is willing to share with me the code or enlighten me wat's the best way to do it n i will be able to start working soon.

Thks a million in advance.