Mailing List Archive


Back to the month index Back to the list index
Brian Andrews (brian@informate.co.nz)
Thu, 30 Jan 1997 11:04:05 +1300 

Message-Id: <199701292200.WAA25039@buttons.ihug.co.nz>
From: "Brian Andrews" <brian@informate.co.nz>
Subject: Re: [mSQL] MS-Access to mSQL?
Date: Thu, 30 Jan 1997 11:04:05 +1300

----------
> From: Kerry Garrison <garrison@delta.net>
> To: brian@informate.co.nz
> Subject: Re: [mSQL] MS-Access to mSQL?
> Date: Thursday, 30 January 1997 09:38
>
> >Different Approach:
> >
> >I have an Access function below which will create mSql insert statements
> >(not tabbed delimited files) for all tables
> >in a db. It will escape single quotes and restrict the length of
> >table and field names. It will also remove spaces from table and field
> >names.
>
> >Please note: this works for Access 7
>
> What exactly does one do from Access to run this function? I am not an
> Access expert. I would appreciate any pointers. Thanks.
>

OK,

You will want to paste this function into an Access module within the
database which you want to export - it exports all tables in a
database. This can be modified easily if you only want to export
a subset of all tables.

Next you can create a Macro to run the function (or a Command Button etc).

The macro will specify the Action "RunCode". At the bottom of the screen
the Action Arguments will be the function name export_mSQL ()

Execute the macro to run the function. It will create a file called
ipacweb.txt in
the temp directory. Change the following line in the code for your
circumstances:

  Open "\temp\ipacweb.txt" For Output As #1

This text file will contain the Drop table, Create Table and Insert
statements
for the database.

Feed this text file thru mSql with msql [db] < ipacweb.txt

It works extremely well for me! I drop the function into each of my
databases
and then run them once a week.

Note: the function was designed for mSql 1.0.16. I will create a new one
with index creation soon (for version 2) but version 2 is too unstable
for me at the moment!

Cheers

brian

----------------------------------------------------------------------------
-
Brian Andrews
InforMate Technologies Limited
Technology Consultants for Information Automation
Auckland, New Zealand
Ph (+64) 9-489-1001
Fax (+64) 9-489-1002
Mob (+64) 21-OFFICE (633-423)
brian@informate.co.nz
http://www.informate.co.nz
----------------------------------------------------------------------------

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!