Hi ,
I need some help on these 2 problems. I get a excel sheet from users.
(1) In one of the column depending on the status of a task, cells are filled with either RED or GREEN color. I import this excel sheet to Access and then generate a report. Now in this report my users wants to see the same colors as in excel sheet. Is there a way to read the color in excel sheet while importing ??
(2) This task column in excel usually has more than 255 characters so when I import in into Access a memo field is created for this particular column. Sometimes I am required to export this access table back to Excel and in that process this memo field gets truncated. Is there any way to work around this problem??
PLEASE HELP SOMEBODY
Thanks in advance,
Isha