Pull Access schema into a SQL Server table
The way we solved this was to use a template db to auto create views against the access linked tables.  Each view was created as

CREATE VIEW AS 
SELECT *
  FROM LinkedServer...Table


Once these views had been created we could pull the column listing from sys.columns joined over to sys.views.

SELECT v.name, c.name
  FROM sys.columns c 
       JOIN sys.views v ON c.object_id = v.object_id 
 WHERE v.name = @viewname


We could then insert this into the table we needed to work with.