Recent questions tagged odbc

0 votes

903 views

1 answer

odbc - Excel: Use a cell value as a parameter for a SQL query

I'm using MS Excel to get data from a MySQL database through ODBC. I successfully get data using an SQL query. But now ... a query? and how can I do it? Thanks. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

748 views

1 answer

odbc - The specified DSN contains an architecture mismatch between the Driver and Application. JAVA

I'm trying to connect to a database made by MS Access using Java, but I cannot seem to manage. I am using ODBC and ... sqle) { System.out.println(sqle); } } } Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

756 views

1 answer

odbc - Excel Power Query. Run multiple queries by list of templates to join tables in different files

I have a question: I have 60+ tables in dbf with columns: year, product, value. Tables have different years data. ... run-multiple-queries-by-list-of-templates-to-join-tables-in-d...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

odbc - Need a row count after SELECT statement: what's the optimal SQL approach?

I'm trying to select a column from a single table (no joins) and I need the count of the number of rows, ... /need-a-row-count-after-select-statement-whats-the-optimal-sql-approach...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

881 views

1 answer

odbc - how to I find out who (help desk) deleted drivers from my work computer - 911

a lot of my drivers disappeared all of a sudden. The help desk here at work is trying to say that I did it. I ... to run one of my access databases and the ODBC drivers are gone....

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

901 views

1 answer

odbc - how to I find out who (help desk) deleted drivers from my work computer - 911

a lot of my drivers disappeared all of a sudden. The help desk here at work is trying to say that I did it. I ... to run one of my access databases and the ODBC drivers are gone....

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags