Database schema and data inserts ?

S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database schema and data inserts ? 2
Exporting database schema 3
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
schema size 2
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
schema to text file 7
reporting database schema 1
BCM Database schema information 1

Top