admin管理员组

文章数量:1026640

I have an ODBC database I can connect to and navigate to correct folder and table. Table has over 200,000 entries and I only want to pull in 258 of them. The column in the table is called WWID and it is format of 12345678. I am wanting to write a SQL query on my connection to save having it pull all the data into the Power Query in Excel. When I try to use a SQL statement it gives me the error:

ODBC: ERROR [HY000] ERROR: Syntax error: Exception parsing query near 'WorkerSnapshotPublic' java.sql.SQLException: Syntax error: Exception parsing query near 'WorkerSnapshotPublic'; Error while executing the query

Table name is correct, column name is correct. Perhaps Data type is incorrect but not sure how to tell.

I gave it the SQL Command:

SELECT *
FROM WorkerSnapshotPublic
WHERE WWID IN ('12345678');

I wanted to be able to have it read in a list of 258 WWID from a CSV but want to start with how to get the command to work.

I have an ODBC database I can connect to and navigate to correct folder and table. Table has over 200,000 entries and I only want to pull in 258 of them. The column in the table is called WWID and it is format of 12345678. I am wanting to write a SQL query on my connection to save having it pull all the data into the Power Query in Excel. When I try to use a SQL statement it gives me the error:

ODBC: ERROR [HY000] ERROR: Syntax error: Exception parsing query near 'WorkerSnapshotPublic' java.sql.SQLException: Syntax error: Exception parsing query near 'WorkerSnapshotPublic'; Error while executing the query

Table name is correct, column name is correct. Perhaps Data type is incorrect but not sure how to tell.

I gave it the SQL Command:

SELECT *
FROM WorkerSnapshotPublic
WHERE WWID IN ('12345678');

I wanted to be able to have it read in a list of 258 WWID from a CSV but want to start with how to get the command to work.

本文标签： sqlODBC ERROR HY000 importing data to ExcelStack Overflow

版权声明：本文标题：sql - ODBC: ERROR [HY000] importing data to Excel - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745651837a2161365.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。