List of columns from a "table"

HCL Domino Domino Forum
1

In Excel 2013, I am connecting to a Lotus Notes database (.nsf) via an ODBC connection. One of the “tables”, I am trying to retrieve data from throws and error: [Lotus] [ODBC Lotus Notes] Too many columns or expression in the statement. I can connect to the server via SQL Server Management Studio linked server.

I do not know what columns are available to choose. Is there a way to query the table to show the list of columns? Is there any way to see this column list using SQL?

2

Subject: DB Visualizer

I downloaded DbVisualizer and connected to the replica via ODBC and was able to see all of the columns in that particular table/form.

https://www.dbvis.com/ https://www.dbvis.com/