Access Datasheet to Excel

  • Thread starter Thread starter Martha W. Stone
  • Start date Start date
M

Martha W. Stone

I had an Access Database written for me to use at work. I'm asking my
question here because the person that wrote the database for me can't answer
this question:

I have a report that pulls data out of the database into a datasheet. It
shows me company names and dollar amounts. How can I get this data into
Excel? I've tried exporting and unless I'm doing it incorrectly, it doesn't
work. I've also tried cutting the data from the datasheet in Access and
pasting it into Excel and that works...until I want to do calculations on
the dollars column.

Any ideas?

Thanks!

Martha
 
Martha W. Stone said:
I had an Access Database written for me to use at work. I'm asking my
question here because the person that wrote the database for me can't answer
this question:

I have a report that pulls data out of the database into a datasheet. It
shows me company names and dollar amounts. How can I get this data into
Excel? I've tried exporting and unless I'm doing it incorrectly, it doesn't
work. I've also tried cutting the data from the datasheet in Access and
pasting it into Excel and that works...until I want to do calculations on
the dollars column.

Any ideas?

Thanks!

Martha
Click to expand...


Martha - Your issue is in Excel, not Access. The Copy & Paste method
is fine, depending on the number of records you're dealing with.
Excel is interpreting your Dollars as Text. Changing the Format
through Format > Cells won't help. One fix goes as follows: In an
empty cell type the number 1. Copy that cell. Highlight the cells
that contain the Dollar values. Right click in the highlighted area.
Paste Special. Multiply. Excel then multiplies your Dollar's by 1
and should now read them as numeric.
 
Hi Martha

i'm surprised that "export doesn't work" ... as this is something i do quite
often and i've not had a problem with it - the steps i use are run the
query - see the results in the datasheet
from the menu choose
file / export - set the file type to excel
give it a name
save it
open excel
file / open - locate exported file
all is well :)

if you'ld like to try the above and then give me an idea of what happens
when you do it - we'll see if we can find a solution, also please let me
know your access & excel versions.

Cheers
JulieD
 
Back
Top