table names

[#1]

How to load all table names from access database in qlikview??

[#2]

Hai,

What do u Mean By Load ing from Acces

Through Connection String U can Access All tables and While Storing Pls Name by u r self

Regards,

Chandu

[#3]

I mean to say how to get all the table names from access database through script in qlikview...

[Anonymous]

Try this:

SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0

In access the system tables are hidden from the user as standard. But it's possible to change the setting.

/Henrik

[jagan]

HI,

Try this query, this query returns only non system tables.

SELECT MSysObjects.Name, MSysObjects.Type

FROM MSysObjects

WHERE MSysObjects.Name Not Like "MsyS*" AND MSysObjects.Type=1

ORDER BY MSysObjects.Name;

Regards,

Jagan.

[jeffmartins]

Hi shreeaaradhya ,

You can use sqltables statement to get all the field names of an ODBC data sorce.

Example:

connect to 'MS Access 7.0 Database; DBQ=C:\Course3\DataSrc\QWT.mbd';

sqltables;

Regards