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