sometimes it's quicker to ask in here than go looking.
I've sliced my single table into many tables (i have 6 areas and 7 things, so er, 42?) in access sql.
Usually when I do what I do normally I link excel to one table in access.
So it's no bother to link the table.
Linking 42 is going to make me want to punch my cock.
How do I do this quickly?
And am I doing the right thing here?
Am I going to create something useless?
sometimes it's quicker to ask in here than go looking.
I've sliced my single table into many tables (i have 6 areas and 7 things, so er, 42?) in access sql.
Usually when I do what I do normally I link excel to one table in access.
So it's no bother to link the table.
Linking 42 is going to make me want to punch my cock.
How do I do this quickly?
And am I doing the right thing here?
Am I going to create something useless?