Create new database from existing table

[Randy Van Sickle]

Is it possible to create a new database from an existing table (or query)
within an existing database.

I have a large access database from which I would like to consolidate just a
small amount of data into a new, much smaller database.

Thanks in advance.

Randy Van Sickle

 

[Al Campagna]

Randy,
Not sure if I understand what you're doing...Do you mean your just trying to make a table smaller, or the whole application? If you
want to create a mini-version of your original app, I'd create a new mdb.

If you want to create a new .mdb file, you can import your previous big table into it.
You could then copy that table's structure, create an append query to append just those
records you want from the big table into the new smaller table. Then delete the original
table from the new mdb, and name the new table the same as the old table name.
In that way, all your forms and queries and reports (imported from your old app) would
still work in the new mdb.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Hi Randy

You can use get external data

Create the new DB then select get external data from the file option and
browse to the table you want to import

Hope this helps

 

[Randy Van Sickle]

Thanks for the responses. Perhaps I should make my objective more clear. I
have an existing .mdb file that consists of many tables, reports, forms,
queries, etc.

I would like to create a new .mdb and within that new database use only one
of the 12 or so tables that exist in the existing database. If I want to
get external data, how would I do so without importing the entire old
database. All I want in the new database is a single table.

Thanks again.

Randy

 

[John Vinson]

I would like to create a new .mdb and within that new database use only one
of the 12 or so tables that exist in the existing database. If I want to
get external data, how would I do so without importing the entire old
database. All I want in the new database is a single table.

Reread Al and Wayne's suggetions. That's precisely and exactly what
they're telling you how to do.

John W. Vinson[MVP]

 

[missinglinq via AccessMonster.com]

RAndy, here's the Step-by-step:

1) Make/open a new database
2) Goto File > Get External Data > Import
3) Select the original database
4) Select the table you want in your new db
5) Click OK

Now your new db will have your selected table!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Randy Van Sickle]

Thank you all for you input. I have achieved the objective. Sorry for
asking what appeared to be dupe questions.