how do I format data from access to work in excel calculations?
 

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.

how do I format data from access to work in excel calculations?
 

Debra Dalgleish shares some techniques:
http://www.contextures.com/xlDataEntry03.html

Phil wrote:

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.

--

Dave Peterson

how do I format data from access to work in excel calculations
 

Thanks Dave, as this info is helpful, the format application does not affect
the imported data from Access, only data added directly to the excel
spreadsheet.



"Dave Peterson" wrote:

Debra Dalgleish shares some techniques:
http://www.contextures.com/xlDataEntry03.html

Phil wrote:

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.

--

Dave Peterson

how do I format data from access to work in excel calculations
 

Make sure that the cells are formatted as General (or anything but Text) before
you type your entries.

If you've already typed the entries (and they're seen as Text), then Debra's
techniques should work ok.


Phil wrote:

Thanks Dave, as this info is helpful, the format application does not affect
the imported data from Access, only data added directly to the excel
spreadsheet.

"Dave Peterson" wrote:

Debra Dalgleish shares some techniques:
http://www.contextures.com/xlDataEntry03.html

Phil wrote:

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.

--

Dave Peterson


--

Dave Peterson

how do I format data from access to work in excel calculations
 

Thanks ... I found that the issue was in the format of the Access fields -
"text" , it could not be reformatted once it got to the excel spreadsheet...
it needed to have been in the correct format in Access -prior- to the data
transfer....

I appreciate your time, thanks again!

"Dave Peterson" wrote:

Make sure that the cells are formatted as General (or anything but Text) before
you type your entries.

If you've already typed the entries (and they're seen as Text), then Debra's
techniques should work ok.


Phil wrote:

Thanks Dave, as this info is helpful, the format application does not affect
the imported data from Access, only data added directly to the excel
spreadsheet.

"Dave Peterson" wrote:

Debra Dalgleish shares some techniques:
http://www.contextures.com/xlDataEntry03.html

Phil wrote:

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.

--

Dave Peterson


--

Dave Peterson