Split access table or querry in several excell sheet

**wcedeno** · 05-24-2011, 08:34 AM

Hello all,

I am having a querry/Table in access with 131000 lines, which obviously is too much for excel and for what I need, I would like a process which can cut it every 5000 or 4000 lines (if I can choose the amout better) the access doc and divide it in differents excel sheets.

Does anyone have any application or process to run in access?

Thanks

**alansidman** · 05-24-2011, 10:06 AM

Add an autonumber field to your table. Create a query and in the autonumber field, specify the records that you want in the criteria, ie. Between 1 and 5000. Export the file to Excel. Now open the query and change the criteria to "Between 5001 and 10000, repeat this until all your records have been exported.

Alan

**wcedeno** · 05-25-2011, 04:46 PM

Originally Posted by alansidman

Add an autonumber field to your table. Create a query and in the autonumber field, specify the records that you want in the criteria, ie. Between 1 and 5000. Export the file to Excel. Now open the query and change the criteria to "Between 5001 and 10000, repeat this until all your records have been exported.

Alan

Thanks for the reply, can you explain more how to achive this? I am a bit lost, how to add an autonumber, is it in design view?

Thanks

**alansidman** · 05-25-2011, 04:49 PM

In your table design add a field. In the type of field put autonumber. This will work only if you do not already have an autonumber in your table already. Close the design. Open the table or query and your new field will be sequentially numbered 1-up.

Alan