Is schema metadata available for Access? 1

[stevexff]

I have an Access DB with about 30 tables, that I need to map onto a much larger number of tables on SQL Server as part of a migration exercise. I'm used to being able to get the schema metadata (table names, column names, column type, nullability etc.) from the system catalog by running an SQL query.

Does anyone know if you can do the same kind of thing for Access? I don't really relish the idea of examining each table in turn in design view to collect this information...

 

[PHV]

Take a look at the TableDefs, Fields and Properties DAO collection.
Another way is to play with ADOX

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RoyVidar]

There are probably a number of ways, I wouldn't be surprised if you found something usefull here thread709-752030 (both OpenShema, ADOX, and some DAO suggestions)

Roy-Vidar

 

[stevexff]

Thanks RV - the other thread has everything I need. Have a star...