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

faster way to save/restore a worksheet in MS Access
 

You cannot save formating in an Access table.

What exactly are you trying to achieve?

MH

"Ben" wrote in message
...
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

faster way to save/restore a worksheet in MS Access
 

Hi MH,
I want to save the cell color/Border/Font/Font size...

Thank you