[SOLVED] How to list MS ACCESS tables?

[erdomester]

Hey everyone,

I would like to list the tables of a MS ACCESS database, but I have not found any solutions yet.

Thank You,

erdomester

[RichardRotterdam]

If you want to read an ms access database using php you'll need odbc.

[erdomester]

No. I have already a program that reads data from a specified table. I just don't know how to manage tables when I don't know their names.. My aim is to put all the tables of the database into an array.

 

[premiso]

http://www.eggheadcafe.com/forumarchives/Access/Jun2005/post23219902.asp

 

SELECT [Name] FROM MSysObjects  WHERE [Type] = 6

[erdomester]

http://www.eggheadcafe.com/forumarchives/Access/Jun2005/post23219902.asp

 

SELECT [Name] FROM MSysObjects  WHERE [Type] = 6

 

Thank you, this is it, but how can i use this? I understand the structure of a simple query like

$sql="SELECT * FROM table_sth";  but retrieving tables names is different..

[erdomester]

Found another solution:

http://hu.php.net/manual/en/function.odbc-tables.php

 

[kickstart]

Hi

 

From when I had to do this. Pretty crude but works:-

 

$result = odbc_tables($OdbcDatabaseConnectionVar);

$tables = array();
while (odbc_fetch_row($result)){
if(odbc_result($result,"TABLE_TYPE")=="TABLE")
{
	echo"<br>".odbc_result($result,"TABLE_NAME")."<br />";
	$cols = odbc_exec($OdbcDatabaseConnectionVar,'select * from `'.odbc_result($result,"TABLE_NAME").'` where 1=2');  // we don't want content
	$ncols = odbc_num_fields($cols);
	for ($n=1; $n<=$ncols; $n++) 
	{
		$field_name = odbc_field_name($cols, $n);
		echo "      ".$field_name."<br />";
	}
}
}

 

All the best

 

Keith