Copy Access table structure to Excel

teachman

Active Member
Joined
Aug 31, 2011
Messages
303
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
 

Forum statistics

Threads
1,078,363
Messages
5,339,758
Members
399,321
Latest member
ladeko

Some videos you may like

This Week's Hot Topics

Top