List of tables in a database

[zzoemie]

Hi,

I wonder if there is a possibility to select a table from a database by using a sort of explorer window.
My problem is this:
I want to import a *.xls file in a table.
I want to be able to select a certain *.xls file from a list (so far no probs) en add it contents to a table selected in a browser window.
A table ofcourse who the exact field structure.

Anyone?

 

[KeithG]

You could use the below SQL to populate a list box.

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=1))

 

[zzoemie]

Is this also possible without showing the system files?

Thanks for the solution.

 

[Mile-O]

Exclude them in the SQL by adding further criteria.

 

[zzoemie]

Thx, ofcourse.