Extracting from excel to acess database
 

I would like to extract data from an excel spreadsheet to an acess
database. However the values which i extracted to the acess database is
the raw data before running a macro to it. Is there a way to extract the
data which is displayed on the excel spreadsheet and not the computed
fomula. I have tried using wks.cells(int colx, int coly).value but the
raw data is extracted instade of the data diaplyed. Please assist to
advise. Thanks in advance.


--
Palvin
------------------------------------------------------------------------
Palvin's Profile: http://www.excelforum.com/member.php...o&userid=29768
View this thread: http://www.excelforum.com/showthread...hreadid=494839

Extracting from excel to acess database
 

wks.cells(int colx, int coly).Text

--
Regards,
Tom Ogilvy


"Palvin" wrote in
message ...

I would like to extract data from an excel spreadsheet to an acess
database. However the values which i extracted to the acess database is
the raw data before running a macro to it. Is there a way to extract the
data which is displayed on the excel spreadsheet and not the computed
fomula. I have tried using wks.cells(int colx, int coly).value but the
raw data is extracted instade of the data diaplyed. Please assist to
advise. Thanks in advance.


--
Palvin
------------------------------------------------------------------------
Palvin's Profile:
http://www.excelforum.com/member.php...o&userid=29768
View this thread: http://www.excelforum.com/showthread...hreadid=494839