30 line table brake

[N1ck9141]

Hi im not sure if its a macro i need BUT..

I basically need to take a table that i have and split it into seperate tables at every 30 lines intervals...e.g.
line 1-30 become table one...

31-60 become table two...

also while doing this i need it to remove all rows with null values any ideas please help im going nuts here

 

[DCrake]

Why do you need to do this? is there a specific reason for this? seems a bit illogical.

David

 

[N1ck9141]

Its just because the text file producedby this auditing tool i use, organsize each set like this with a line brake every 30 rows and that cant be changed sadly

 

[DCrake]

Not sure if you ar coming or going? First you say that you have a table in access that you want to split into 30 record chunks.

Then you say you have a text file that has a line break every 30 rows. Are you trying to import a text file or export an Access table?

Or are you doing both. If so can you supply a same of the text file.

David