Import debits and credits into multiple quickbook files with QBSdk 8.0 and vb.net Asp.net

I get a download from the bank in excel, it will have 20 accounts in the download.  I need to read these transactions insert them into sql server 2005 and then for each account insert the records into each company.  I can do with J/E or cash (deposit / check).

I have looked at the QBSdk 8.0 all the documentation and have no idea how to do even a barebones insert please help i have spent 3 weeks and have nothing and my NEW boss is wondering

Thanks!~
mikezx10Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jbhtghCommented:
Do you have a stored procedure to insert with or are you using SQL Code, I would recommend a stored procedure.

Do you need to insert into SQL Server, or Quickbooks ? or they the same db
0
mikezx10Author Commented:
I can handle the SQL Server insert, i need help with selecting and inserting into quickbooks
0
jbhtghCommented:

Maybe this:

http://doc.qodbc.com/qodbc/20/tables...ml?tables_id=2Click on the table you want the info on. There is a column called Req Ins which I believe denotes whether the field is required for an record insert.

or

You would have to pay for this one, but if the New boss is wondering, it may be worth it.

http://www.bigredconsulting.com/AboutCreator.htm



0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mikezx10Author Commented:
the 1st link didnt work, I will read the 2nd one tonight, looks possible!
0
ZillionTechCommented:
You can find services that will do custom programming o r do it as a one time job.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.