If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exporting calculated values
How do I set up an Excel worksheet to export calculated values into an Access
database? Susan |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|