Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Exporting calculated values
How do I set up an Excel worksheet to export calculated values into an Access
database? Susan |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Exporting calculated values
Susan
You do it the other way around. Open Access and Import from Excel. The data imported can be linked to update as Excel updates. See Access Help on "import data" Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 13:15:01 -0700, Susan wrote: How do I set up an Excel worksheet to export calculated values into an Access database? Susan |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Exporting calculated values
Do I have to format the cells containing formulas in Excel in order for them
to import correctly into Access. "Gord Dibben" wrote: Susan You do it the other way around. Open Access and Import from Excel. The data imported can be linked to update as Excel updates. See Access Help on "import data" Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 13:15:01 -0700, Susan wrote: How do I set up an Excel worksheet to export calculated values into an Access database? Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
How do I generate a list from a range of values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
when I add values in cells which have been calculated with percen. | Excel Discussion (Misc queries) |