Copy Access table structure to Excel

teachman

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

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,090,138
Messages
5,412,685
Members
403,439
Latest member
KalengoPhiri

This Week's Hot Topics

Top