| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Data easily from database Excel 2003 | Excel Discussion (Misc queries) | |||
| Extracting Records From Excel Database | Excel Discussion (Misc queries) | |||
| Extracting data without using database functions | Excel Worksheet Functions | |||
| extracting contact info to a database | Excel Discussion (Misc queries) | |||
| Extracting info from a database | Excel Programming | |||
Hybrid Mode
