How to display the metadata information?

[Anonymous]

Hi ,

I need to display the metadata information as a table  in the Welcome page (One of the rows in the table could be as below)

1. Data source---Excel File( From where the table data has been added as a row)

2.Data Last Loaded --- particular date.and time.and day if it is possible.

Many thanks ,

Sharma.

[#2]

Hi,

We have the functions like

Documentname() for document name and reloadtime() for last reloaded time.we need to have the tables list so we can enable system fields in that fields we have tables,it has all the table names in a list box

[Anonymous]

Hi Rakesh ,

Thanks for the reply but i didnt understand ".we need to have the tables list so we can enable system fields in that fields we have tables,it has all the table names in a list box."

Regards,

Sharma

[rustyfishbones]

Create an ODBC Connection to the Excel file, something like

ODBC CONNECT32 TO [Excel Files;DBQ=C:\Users\Alan.PRINCIPAL\Desktop\Budgets\2011.xlsx];

tables:

SQLTables;

DISCONNECT;

This will give you a list of the Excel Tables or sheets

[ashfaq_haseeb · Accepted solution]

Hi,

Check if this helps

Regards

ASHFAQ

[Anonymous]

Hi Alan,

Thanks for the reply But i am wondering how would i display as a  metadata table in the homepage.

Regards,

Sharma

[Anonymous]

Excellent solution