How to export more than 65000 rcds from Access to Excel 2007

[SKV]

I have a table with 500,000 rcds and on exporting it only exports 65000 rcds.
Please advice

Thanks
SKV

 

[boblarson]

How are you exporting it and what version of Access are you using?

 

[SKV]

I have Access 2007, I tried both the options; copy pasting and using export function by right click on the table

is there any other way???

 

[boblarson]

I have Access 2007, I tried both the options; copy pasting and using export function by right click on the table

is there any other way???

Yeah, try using my Export code. It worked for me with a set of 250,000 records going into Excel 2007 which can handle it.

Put the code from here into a standard module, name the module basExport and don't modify the function in any way - at least not at first.

Make sure you have a DAO reference set in Access.

 

[SKV]

tried to paste and run your code but not able to run it. I am just basic in VBA.

What DAO should I activate (3.6 object library)? I tried this and getting error "Name conflicts with existing module/prject or object library"

Please advice

 

[boblarson]

tried to paste and run your code but not able to run it. I am just basic in VBA.

What DAO should I activate (3.6 object library)? I tried this and getting error "Name conflicts with existing module/prject or object library"

Please advice

The DAO you already have a reference to then (it is ACE - the new database engine for 2007, I specified that as some don't have a reference set).

So, where did you paste it and how did you try to run it?

 

[SKV]

I created a new module and pasted your code there.

Can you call me at 980-236-2304 and walk me through

 

[boblarson]

Unfortunately no. I'm at work right now and doing this stuff in between tasks as I wait for things to happen.

So, you didn't answer the part about how did you call it and what error happens when you try to run it.

 

[SKV]

I pasted the code in the module

 

[HiTechCoach]

I pasted the code in the module

Make sure to name the module with a name that does NOT match the function in the module.