[thelist] MS Access CREATE TABLE

Ken Moore psm2713 at hotmail.com
Tue Jan 6 20:36:54 CST 2004

Hi all,

David Mitchell wrote:

>Hi Folks,
>I am stuck working with an MS Access database. I am much more familiar
>working with SQL Server. This leads me to my question: Is there any way
>to generate CREATE TABLE scripts for all the tables in an access
>database sorta the same way one can do this with SQL Server?

I'm not certain what you are trying to do. There is a Make-table query. This 
might work if you attach to another table - MS SQL using ODBC, perhaps - and 
then run a query off of that remote table.



Take advantage of our limited-time introductory offer for dial-up Internet 
access. http://join.msn.com/?page=dept/dialup

More information about the thelist mailing list