Oops. Your question was about exporting - not importing.

What exactly are you doing now?

Are you using VBA to write the values to a text file?

What about the option of looping and writing the data to a database?

If you're copying and pasting - that's why you're timing out.