View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Heads up!

Please recall that an Excel sheet has 65,536 rows (2 to the 16th power,
for the math geeks). If your Access table has 240k records you'll
exceed Excel's capacity to handle the data on a single sheet, meaning
you'll have to come up with a fistful of workarounds to accommodate
your data.

It sounds like you should work from Access, rather than Excel. But
that's just me, Mr. Vegas.

Pontification ends!