Split access querry in several excell sheet

[wcedeno]

Hello all,

I am having a querry 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/process/methode to run in access?

Thanks

[orange]

Just curious, how do you determine which 4 or 5000 line you put out to Excel?
Can you describe the "big picture" of where the data is; what you're going to do with the output; why excel etc?

We can't guess what "for what I need" really means.

[wcedeno]

Hi Need to upload the info from excel to an external system, wich accept from 5000 or less, the big issue is to cut it manually to export it to excel, it takes time and maximize the error margin.

Thanks

[wcedeno]

Can Anyone else respond to my question?

Thanks