Hi,
I'm using Office 2007. I've got an Access table which contains approximately 3 million records. I would like Excel to import this Access table into multiple workbooks of 1 million records each. I'm looking for a VBA macro for to either export from Access or a VBA macro to import to Excel. The end result I want to achieve is to have 3 Excel files with 1 million records each.
Could you help me with the code?
Thanks.
I'm using Office 2007. I've got an Access table which contains approximately 3 million records. I would like Excel to import this Access table into multiple workbooks of 1 million records each. I'm looking for a VBA macro for to either export from Access or a VBA macro to import to Excel. The end result I want to achieve is to have 3 Excel files with 1 million records each.
Could you help me with the code?
Thanks.