topic table names in QlikView

table names

Wed, 21 Nov 2012 05:19:26 GMT

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

Wed, 21 Nov 2012 05:25:04 GMT

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

Wed, 21 Nov 2012 05:28:58 GMT

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

Anonymous — Wed, 21 Nov 2012 06:21:28 GMT

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 — Wed, 21 Nov 2012 06:50:16 GMT

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 — Wed, 21 Nov 2012 18:14:04 GMT

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