K
Ket
Hello,
I am using Office 2003. I have an access db that contains a number of
tables.
I have been asked to export two of these tables to Excel. The issue is
that, as you are probably aware, Excel has only 65k+ rows. The access
tables has in excess of 400k+ rows. Is there any way in which the data
can be exported, such that after the first 65K rows are exported, the
next 65K are exported to the next worksheet and so on and so forth?
The end result would be one workbook containing 6 or 7 worksheets each
with 65K rows of data.
Thanks in advance for your help.
Ket
London (UK)
I am using Office 2003. I have an access db that contains a number of
tables.
I have been asked to export two of these tables to Excel. The issue is
that, as you are probably aware, Excel has only 65k+ rows. The access
tables has in excess of 400k+ rows. Is there any way in which the data
can be exported, such that after the first 65K rows are exported, the
next 65K are exported to the next worksheet and so on and so forth?
The end result would be one workbook containing 6 or 7 worksheets each
with 65K rows of data.
Thanks in advance for your help.
Ket
London (UK)