Make table query help ?

N

NickTheBatMan

I have a large table and want to export from that table into lots of
others...

In my table I have a CatNr field which I would like to name all my
exported tables as - there's over 1600 entries which will end up in 95
tables...

I'm hopeful that it's going to be easy to create some SQL to do this
in one fell swoop ?

TIA

Nick
 
B

BruceM

Without knowing anything about your database other than it has a table with
a CatNr field it is difficult to be specific, but why do you want to break
the large table (how large?) into 95 separate tables? It sounds as if you
will be using data as table names, which is not sound design practice.
Generally, you would use a query to sort and otherwise arrange the data.
"Fell swoop" refers to an evil occurence, which it may be if you proceed
along the proposed lines. However, details are needed before a fully
informed response is possible.
 
J

John W. Vinson

I have a large table and want to export from that table into lots of
others...
Click to expand...

Why on Earth would you want to do that?

A database with *two* tables of identical structure is very suspect. A
database with 95 identically structured tables is ipso facto WRONG.

Please explain the context, and what real-life task you're trying to
accomplish. I'm sure it can be done - and yes, you can write VBA code to run
95 make-table queries if that by some strange stretch should be appropriate -
but I bet there's a much easier solution.
 
N

NickTheBatMan

Why on Earth would you want to do that?

A database with *two* tables of identical structure is very suspect. A
database with 95 identically structured tables is ipso facto WRONG.

Please explain the context, and what real-life task you're trying to
accomplish. I'm sure it can be done - and yes, you can write VBA code to run
95 make-table queries if that by some strange stretch should be appropriate -
but I bet there's a much easier solution.
Click to expand...

I am working with a database that's massively more complex than I know
how to.

It has the table which has been populated by someone specifically as a
telephone book and has been added too freely by many people over the
past year +

I've been given the task of making a better job out of the format of
the phone book and need to get a lot of the names and number out into
another part of the db to do other things.

I have also created another separate 20 tables that contain somewhat
similar names and numbers and I want to cross refer them to ensure I'm
getting the right people and numbers into the right groups.

I will then be combining it all again into the one big table again...

And this all has to be completed by this Friday - that's 3 days !

Think I'm loosing the battle !

Nick
 
J

John W. Vinson

I am working with a database that's massively more complex than I know
how to.

It has the table which has been populated by someone specifically as a
telephone book and has been added too freely by many people over the
past year +

I've been given the task of making a better job out of the format of
the phone book and need to get a lot of the names and number out into
another part of the db to do other things.

I have also created another separate 20 tables that contain somewhat
similar names and numbers and I want to cross refer them to ensure I'm
getting the right people and numbers into the right groups.

I will then be combining it all again into the one big table again...

And this all has to be completed by this Friday - that's 3 days !

Think I'm loosing the battle !
Click to expand...

There is NOTHING that you can do with a new table which cannot also be done
with a Select Query.

You have not posted any specific details of your table structure.

You have not posted any examples of the make-table queries that you are trying
to run.

We'll be glad to help, but we cannot see your screen and do not know what
you're struggling with (other than that you're struggling). Give us some help
here...?
 
Top