Is it possible please to extract table structure and data?

[ignite]

Hello,

Is it possible please to extract a tables structure and data into SQL in Access. I know how to do this in phpmyadmin (an internet based DBMS) but not so sure in Access.

What I want to do is to create an identical version of the table in SQL Server, so therefore require the structure and data in SQL format if possible.

Any help is much appreciated, thank you.

 

[ignite]

Thank you for the reply, when I try and run the wizard it reports that:

Object variable or With block variable not set

Any ideas please?