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
|
|
select into |
Author |
Message |
|
Posted : 2009-02-09 14:41:59 |
i'm getting various errors when i try to use the INTO clause.
is this feature not supported? example: select * into newtable from customer
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-09 17:24:29 |
No you can't create tables in QuickBooks using QODBC. In MS Access do a append query, something like:
INSERT INTO tblAcct (ListID, Name, IsActive, FullName, AccountType, AccountNumber) SELECT Account.ListID, Account.Name, Account.IsActive, Account.FullName, Account.AccountType, Account.AccountNumber FROM Account;
tblAcct is a local MS Acces table and Account is a QODBC/QuickBooks table. |
|
|
|
|
Posted : 2009-02-10 03:11:00 |
i'm lost.
how does the sql tell qodbc that the tblACCT is in access..... because the connection string is pointing to qodbc?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-10 10:01:45 |
Try using the Append Query Wizard in MS Access to guide you thru. |
|
|
|
|
Posted : 2009-02-10 10:38:02 |
ahhhhhh, i think you believe that i have linked the QB tables inside msaccess. there are no linked tables, so i cant reference the QB tables directly from msaccess. there are just too many tables to have them all linked up, too many dde requests-possible broken links, and speed issues.
i have to create a query in access that can point to data outside the database (without being 'linked' in access). ----how would i include the QODBC connectionstring in an sql string----that way it would know where the data was coming from when the query runs......
OR, i have to execute the qodbc query in VBA code, and save THOSE records in a table inside access, so an access report can run against it. ----but not sure how to move the records returned from the qodbc query into an access table, WHILE the qodbc connection is still active.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-10 11:36:43 |
|
|
|
|
Posted : 2009-02-10 15:07:19 |
i'm not intending to misuse this help center, i appologise for my persistence. I have been to the microsoft forums but havent gotten anything useful there, except a couple folks who suggested that the people who handle the odbc should know. so here i am.
thanks for the link, but unless i miss my guess, that code looks like it does the same thing as if i were to link the table into access, which is what i'm trying NOT to do.
i'm looking for a way to do a select-into which reads the qodbc and creates a table in access. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-10 17:57:20 |
QODBC is a ODBC driver. Normally to use QODBC in MS Access you must either link or import the external table. Tables can be linked individually and even linked and unlinked within a sub-procedure.
But in this example: Running an sp_report in Access using VBA you will find what you've looking for. |
|
|
|
|