HOW NOT TO CREATE A TABLE FROM A "MAKE TABLE QUERY" W/NO DATA

[WIZEGAL]

Hi - I have a macro set up that runs about 120 "make table" queries. this is
run on a daily basis - but not all the table may have data. What do i need
to do so that only the queries with rows create a table. You help is greatly
appreciated..as this would save me from having to open each table to see if
there is any data to move to my next step.

thanks
Anna

 

[John W. Vinson]

Hi - I have a macro set up that runs about 120 "make table" queries. this is
run on a daily basis - but not all the table may have data. What do i need
to do so that only the queries with rows create a table. You help is greatly
appreciated..as this would save me from having to open each table to see if
there is any data to move to my next step.

thanks
Anna

WHOA. Stop. Take your hands off the keyboard and slowly step away.

It's very rare to need even *one* MakeTable query. 120 maketable queries will
bloat your database dreadfully, and are VERY unlikely to be necessary. Even
*two* tables of identical structure in your database indicates incorrect
design.

WHY? What is the function of these tables? What can you do with them that you
cannot do with probably just one parameter query?

Context please!

 

[WIZEGAL]

What I need is: I import a large csv file of data that is downloaded from
our daily UPS shipments. within this file are the over 120 or so vendors that
we service. I need to break this down to create one file per vendor so that
the data can then be emailed to each individual vendor. This was previously
being cut and pasted from excel - that was a nightmare. If there is another
way to do this please - please advise!!

Hey isn't there a way then to email the individual tables direct from
Acces...guess should be another topic huh.

 

[John W. Vinson]

What I need is: I import a large csv file of data that is downloaded from
our daily UPS shipments. within this file are the over 120 or so vendors that
we service. I need to break this down to create one file per vendor so that
the data can then be emailed to each individual vendor. This was previously
being cut and pasted from excel - that was a nightmare. If there is another
way to do this please - please advise!!

You need *one* table, *one* parameter query with a parameter to select the
vendor, and *one* Report containing the information that the vendor needs;
you'll then need just a little bit of VBA code to loop through the table of
vendors (you DO have a table of vendors I hope...?), launch the report 120
times, and use SendObject to email the report.