How do I set up an Excel worksheet to export calculated values into an Access database? Susan
S Susan Sep 6, 2006 #1 How do I set up an Excel worksheet to export calculated values into an Access database? Susan
G Gord Dibben Sep 6, 2006 #2 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
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
S Susan Sep 11, 2006 #3 Do I have to format the cells containing formulas in Excel in order for them to import correctly into Access.
Do I have to format the cells containing formulas in Excel in order for them to import correctly into Access.
