View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default faster way to save/restore a worksheet in MS Access

Hi,
I'm looking for a faster way to save/restore a worksheet including the
cell formating in an MS Access table. I'm using Windows and Office 2k
I have built a macro to loop on all the cells, put the cell data and
formating in a string with "~" as separator then save it in MS Access table.
But the save and restore took a very long time.

Is there a faster wasy to do this?

Thank you very much.
Ben