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
|