Export data - Access 2003 to Excel 2003

Export data - Access 2003 to Excel 2003

Post by U3RhdHR » Wed, 02 Jul 2008 07:11:00


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 ".
 
 
 

Export data - Access 2003 to Excel 2003

Post by bhicks11 v » Wed, 02 Jul 2008 09:54:11

Hi Statto,

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

http://www.yqcomputer.com/
=

Bonnie
http://www.yqcomputer.com/



--
Message posted via http://www.yqcomputer.com/