Very Computer

by **Rob Goe** » Sun, 25 Jun 1995 04:00:00

I have a system where there will be an existing access db with a # of
tables created by another app. On installation of my vb app in this
existing environment I would like to create some new tables in this access
db, but ideally I'd like to do it by 'merging' some table defs from an
access db that I plan to provide with my setup.

Access 2.0 allows you to Import table definitions into an existing db. I
do not see this capability in visual basic. (There is discussion in the
vb tips & techniques on how to attach tables, but not import).

Does anyone have any suggestions how to accomplish this task in a
relatively efficient manner.

TIA.

--

by **Software Development Grou** » Wed, 28 Jun 1995 04:00:00

Quote:> Access 2.0 allows you to Import table definitions into an existing db. I
> do not see this capability in visual basic.

It's no great loss. At design-time, you can just use Access to import the tables,
and at run-time the Access support for importing from non-Access formats
(like comma-delimited) isn't reliable enough for production code, and
you'd probably need to drop into Basic anyway.

If you're building Access tables from VB, then the easiest way is to use
Access 2.0 and an SQL CREATE TABLE query (NB - not a Make Table query)
You can feed design information into this from hard-coded VB, or INI files,
or whatever (I've even seen it done from System Architect). It wouldn't be difficult
to iterate through the source database's table designs and pull it from there.

--

Database development for mailorder, marketing & general business users.

Very Computer

Importing (Merging) Access Tables?

Importing (Merging) Access Tables?

Importing (Merging) Access Tables?