Database schema and data inserts ?

[Stuart Crow]

Hello all
Apologies for cross-posting, but I was not sure which group to ask.
I have very little experience with Access, and have a small Access
2002 database, the schema and data for which I wish to save as sql
files. I am more used to SQL Server, where there is a command to
Generate SQL which can generate a schema, and a program SQLExecMS
can be used to create a SQL file containing Insert statements for
data in a table.
Does anyone know if this type of functionality is available for
Access 2002 ?
TIA
Stuart

 

[Joe Fallon]

Scripting of the schema is *not* built-in to Access.
But you can always copy the entire .mdb so....

3rd party tools or DAO code could generate a script for you if truly needed.

There is an upsizing wizard to help transfer schema from Access to SQL
Server.
It first appeared in A2000 and got better in each version since.