Comments by Puj07 (Top 1 by date)

No programming just some way to do this. I googled & found one solution which is below but do not know how to use it in excel. Please help.

FirstKeyValue = 0
LimitKeyValue = 1048576
NameCounter = 1

while FirstKeyValue <= MaxKeyValueInTable
DoCmd.OpenQuery "QueryWhichFetchesTheKeyRange", acViewNormal, acEdit
DoCmd.OutputTo acOutputQuery, , acFormatXLS, "FilePathAndName" & NameCounter & ".xls", True

LimitKeyValue = LimitKeyValue + 1048576
FirstKeyValue = FirstKeyValue + 1048576
NameCounter = NameCounter + 1
wend