select too many records for clipboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a macro that exports a query(70,000 records) from a linked table via
odbc(6.5 million records) to a spreadsheet.
it then reimports the spreadsheet as a table, and runs additional queries on
the table.

i get the "you've selected too many records for the clipboard, 65,000 max"

i don't know how to get around this.

could i have the query break the table into 2 files, and then append them to
one upon import ?
 
samuel said:
i have a macro that exports a query(70,000 records) from a linked table via
odbc(6.5 million records) to a spreadsheet.
it then reimports the spreadsheet as a table, and runs additional queries on
the table.

i get the "you've selected too many records for the clipboard, 65,000 max"

i don't know how to get around this.

could i have the query break the table into 2 files, and then append them to
one upon import ?
Click to expand...


Any particular reason you're outputting to the spreadsheet in the first
place? Why not just have the query insert the data from the ODBC source
into a table directly?
 
guess i didn't know i could use a query to output to a table ?

could you give further instruction?
 
Back
Top