faster way to save/restore a worksheet in MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You cannot save formating in an Access table.

What exactly are you trying to achieve?

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

Thank you
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Faster way to find and replace? 1
What are the steps to fix damaged MDF files in SQL Server? 0
Deselect a worksheet? 3
How to export table from outlook into ms access table? 0
Faster way to loop through two ranges 8
Treating WorkSheet As MS Access Table? 2
Save & Restore a column 4
Need Macro... 8

Back
Top