Extracting from excel to acess database

P

Palvin

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.
 

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

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Query from Access Database based on user selected parameters in Excel 2
Query Data in Excel S/S from Access DB 2
Help with Excel sheets 3
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
How to extract complete HTML code in Excel 0
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Extracting data from an excel spreadsheet 3

Top