Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Is it possible to move sql server data into QB??!! HELP |
Author |
Message |
Dan1 |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-01-18 |
|
Profile |
|
Posted : 2008-01-18 01:00:53 |
This is what we are trying to do.
We have a sql server running on a machine that collects data from customers from our website.
We have QB running on a totally different machine. We have QODB installed on this machine. I can run VB demo and view the tables and the data in QB.
NOW WHAT? DO I need one more license of QODBC so I can install it on the machine running SQL SERVER?
I am totally confused and the tutorials are even more confusing. Can someone please help?
How do I dump data from SQL server tables into QB on a different machine? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-18 09:20:43 |
You will need to export the SQL Server data into a comma delimited text file (CSV). Copy the file to the computer running QuickBooks and then use a program or script to read the exported file and format the data into INSERT statements that are executed using QODBC. |
|
|
|
|