Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 6th 06, 09:15 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 271
Default Exporting calculated values

How do I set up an Excel worksheet to export calculated values into an Access
database?

Susan

  #2   Report Post  
Old September 6th 06, 11:15 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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   Report Post  
Old September 11th 06, 06:27 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 271
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get correct results when LOOKUP with calculated numbers onthemountain Excel Worksheet Functions 2 July 20th 06 01:13 AM
How do I generate a list from a range of values robo7084 Excel Worksheet Functions 2 July 6th 06 01:48 AM
Return Range of Numerical Values in Single Column based on Frequency Percentage Sam via OfficeKB.com Excel Worksheet Functions 9 October 28th 05 11:01 PM
How can I break values apart that are in the same cell? Phil Excel Worksheet Functions 3 October 4th 05 03:41 PM
when I add values in cells which have been calculated with percen. David Excel Discussion (Misc queries) 3 April 26th 05 03:50 PM


All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017