Export data - Access 2003 to Excel 2003

[Statto]

Hi,
I am running a VBA looping program which opens a query in access and exports
data to different workbooks, this looping process works fine. However one
query exceeds 65536 rows.
Does anyone know how I can code around this to split the data into two
worksheets within the same workbook... or even three worksheets if required.
One suggestion has been to export to text then split the text file, however I
would rather not use this method has the above process is one step in a
number of steps.
I am using the "DoCmd.TransferSpreadsheet ".

 

[bhicks11 via AccessMonster.com]

Hi Statto,

I found this answer on another forum that might help you:

http://www.utteraccess.com/forums/s...ch=true&where=&Zu=58984&Zd=l&Zn=&Zt=71&Zs=&Zy
=

Bonnie
http://www.dataplus-svc.com