Database structure

C

Curtis McGrath

how can I export my access 2000 database structure without having all the
old data
 
C

Chriske911

how can I export my access 2000 database structure without having all the old

create a new database and use file/get external data/import from the
toolbar
select all the stuff you need from the original database
click on the options on the right of the window
and below the import screen you can set the option to definition only

grtz
 
R

Rick B

When you go to import the tables, it will ask you if you want the data or
jsut the structure.
 
C

Curtis McGrath

thanks
Chriske911 said:
create a new database and use file/get external data/import from the
toolbar
select all the stuff you need from the original database
click on the options on the right of the window
and below the import screen you can set the option to definition only

grtz
 
D

Dirk Goldgar

Curtis McGrath said:
how can I export my access 2000 database structure without having all
the old data

Create the new database, and from within that database, use File -> Get
External Data -> Import... to import the tables and other object from
the old database. However, click the "Options >>" button on the Import
Objects dialog to show the options you can select, and choose the option
to import "Definition Only" for the tables, not "Definition and Data".
 
Top