Try the following SQl Query, you can use it Excel 2007.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION

GO