> 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 :-) )
There are macros out there for this. I use one to convert Access
databases
to MySQL, but I've also seen Access -> MSSQL and other converters. I
don't
have the URL to that site where I saw those macros right now but if you
really want them, then I guess I can dig it up.
Erki
------------------------------------------------------------------------------
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.
