Skip to content

Access a table from an MDB file via ODBC

From Windows, load odbc.k into your q session, and then load the MDB file.

C:>q w32\odbc.k
q)h: .odbc.load `mydb.mdb

This loads the entire database, which may consist of several tables. Use .odbc.tables to list the tables.

q).odbc.tables  h
`aa`bb`cc`dd`ii`nn

Use .odbc.eval to evaluate SQL commands via ODBC.

q).odbc.eval[h;"select * from aa"]

Q client for ODBC