|
 |
access thread: code to drop out database structure
Message #1 by gbrown@c... on Wed, 31 Oct 2001 11:15:41
|
|
Hi all
Could anyone point me in the direction of some code/method to do the
following
I have an existing MDB which I want to recreate in code ie
create database ...
create table xyz (field1 char(10)....
Insert into xyz....
etc etc
This must be similar to what the upsizing wizards must do in order to send
the data to SQL Server.
Hope this is sort of clear what I am trying to do!
Any clues would be gratefully received.
Regards
Graham
Message #2 by Dave Sharpe <pmmgpgp@y...> on Wed, 31 Oct 2001 05:05:21 -0800 (PST)
|
|
Graham:
I have never used this ( nor ever analyzed it ), i just
remembered that I'd seen it in my travels.
Here is what the author says about his code:
"CreateMDB will analyze and dump the sturture of an
Access database into a BAS-module, you can include
in your own project. From your own project you can
now create an access database on the fly."
("sturture" is his typo not mine )
The code was rated a 4 1/2 out of a possible 5 on the
site.
The 3 lines below are the url ( sometimes I really
curse word wrapping) .
http://www.planet-source-code.com/xq/ASP/txtCodeId.22085/
lngWId.1/qx/vb/scripts/ShowCode.htm
Dave
--- gbrown@c... wrote:
> Hi all
>
> Could anyone point me in the direction of some
> code/method to do the
> following
>
> I have an existing MDB which I want to recreate in
> code ie
>
> create database ...
> create table xyz (field1 char(10)....
> Insert into xyz....
>
> etc etc
>
> This must be similar to what the upsizing wizards
> must do in order to send
> the data to SQL Server.
> Hope this is sort of clear what I am trying to do!
> Any clues would be gratefully received.
>
> Regards
> Graham
Message #3 by gbrown@c... on Wed, 31 Oct 2001 16:09:45
|
|
Thanks very much!
Regards
Graham
> Graham:
>
> I have never used this ( nor ever analyzed it ), i just
> remembered that I'd seen it in my travels.
>
> Here is what the author says about his code:
> "CreateMDB will analyze and dump the sturture of an
> Access database into a BAS-module, you can include
> in your own project. From your own project you can
> now create an access database on the fly."
> ("sturture" is his typo not mine )
>
> The code was rated a 4 1/2 out of a possible 5 on the
> site.
>
> The 3 lines below are the url ( sometimes I really
> curse word wrapping) .
>
> http://www.planet-source-code.com/xq/ASP/txtCodeId.22085/
> lngWId.1/qx/vb/scripts/ShowCode.htm
>
> Dave
>
>
> --- gbrown@c... wrote:
> > Hi all
> >
> > Could anyone point me in the direction of some
> > code/method to do the
> > following
> >
> > I have an existing MDB which I want to recreate in
> > code ie
> >
> > create database ...
> > create table xyz (field1 char(10)....
> > Insert into xyz....
> >
> > etc etc
> >
> > This must be similar to what the upsizing wizards
> > must do in order to send
> > the data to SQL Server.
> > Hope this is sort of clear what I am trying to do!
> > Any clues would be gratefully received.
> >
> > Regards
> > Graham
|
|
|
View Cart
