sure...
To start with, you need to know the syntax of CREATE TABLE syntax in sql - I
don't offhand, but it's pretty easy offhand.
Then, you can "scroll" through your fields and indexes collection of your
recordset - you can obtain the names, and other properties, such as field
type and size.
With this information, you can dynamically create a text string that can be
saved into a .SQL text file (be sure to use Print statement in basic to
avoid quotes).
I hope this helps...
Tom
ICQ: 2575057
-----Original Message-----
From: Eron Cohen <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, July 03, 2000 8:58 AM
Subject: OT: MS Access SQL
>Hi Folks,
>
>I am wondering if anyone knows of a way to have MS Access spit out the SQL
>necessary to create the tables that make up a given database. In other
>words, I'd like to do some kind of export that would export just the
actual
>SQL statements that would create identical table structures in a new
>database if they were run. I know you can do this with SQL server, but I
am
>wondering if there is a way to do this from MS Access 2000 (without
upsizing
>to SQL server first :-) )
>
>Thanks,
>
>Eron
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
