Copy Access table structure to Excel

[teachman]

I have an Access database that is being converted to another language and I need to know all the various pieces and parts to create an SQL script that creates a table. So, I need to know the column's parameters (data type, data type, etc.). I really don't want to do that for hundreds of columns that are in the Access database by viewing the table structure in the View table structure and transfer all the info needed to make a column on a column by column basis.

So, what I'm hoping for is some way to copy just a table's structure from Access and paste it into Excel.

Thanks,

George Teachman

 

[Joe4]

See here: https://access-programmers.co.uk/forums/showthread.php?t=153318