T
Tony Girgenti
Hello.
I'm trying to copy customers from an "ODBC connection to QuickBooks" to an
"Access MDB" table called "QB CUSTOMERS".
The first thing i do is delete the customers from the Access table using an
SQL String as "DELETE FROM [QB CUSTOMERS]". That works OK.
Next, i connect to the ODBC Quickbooks customer table and insert the
customer table FullName field into the "QB CUSTOMERS" table using an SQL
String as "INSERT INTO [QB CUSTOMERS] (CUSTOMER) SELECT FullName FROM
QODBC.[QuickBooks Data].Customer;"
In a Try/Catch, it blows up on the statement
"qbCustomersODBCCommand.ExecuteNonQuery()" and i use a message box to
display the "System.Data.Odbc.OdbcException" message string. The error
message is "Error [42000] [QODBC] Expected lexical element not found:
SP_REPORT"
Does anybody know how to do what i am trying to accomplish ?
Any help would be gratefully appreciated.
Thanks,
Tony
I'm trying to copy customers from an "ODBC connection to QuickBooks" to an
"Access MDB" table called "QB CUSTOMERS".
The first thing i do is delete the customers from the Access table using an
SQL String as "DELETE FROM [QB CUSTOMERS]". That works OK.
Next, i connect to the ODBC Quickbooks customer table and insert the
customer table FullName field into the "QB CUSTOMERS" table using an SQL
String as "INSERT INTO [QB CUSTOMERS] (CUSTOMER) SELECT FullName FROM
QODBC.[QuickBooks Data].Customer;"
In a Try/Catch, it blows up on the statement
"qbCustomersODBCCommand.ExecuteNonQuery()" and i use a message box to
display the "System.Data.Odbc.OdbcException" message string. The error
message is "Error [42000] [QODBC] Expected lexical element not found:
SP_REPORT"
Does anybody know how to do what i am trying to accomplish ?
Any help would be gratefully appreciated.
Thanks,
Tony