DBTABLENAME(database, index)

The DBTABLENAME function returns the name of a specified table in a database.

database is the name of a database and must include the full path if not in the same directory as the open document.

index is the table number, starting at 1.

For example, you know a database called wineshop, located in a folder c:\ability\samples, contains at least one table:

DBTABLENAME("c:\ability\samples\wineshop.adb", 1)

returns the name of the first table in the database.

Suppose you enter "c:\ability\samples\wineshop.adb" into a cell in a spreadsheet, say A1. Then the following:

DBTABLENAME(A1, DBTABLECOUNT(A1))

returns the name of the last table.

See also:

DBTABLECOUNT(database)

Other remote functions