I have been looking for information on this, and can't get a clear answer. I am developing an ASP site using an Access database, and eventually, I will be moving the whole thing over, and importing ...

I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view?