Exporting to Excel

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

I am using a simple query to group and count records
according to the value of one of my variables. I then
export the 'count' column of the outcome to Excel by
copying and pasting. However, I then have difficulty in
manipulating the data in Excel in the normal way - for
example, I can't format the numbers to include a comma
separator and I can't sum the numbers using SUM. What do
I need to do to the data I export from Access to be able
to use Excel as expected?

Any help would be much appreciated.

Jim Jones
Gaborone
Botswana
 
Export the query itself using the File | Export action from database window.
Then you can work with the column that you want. Your method is changing the
data into a text format, most likely, and EXCEL no longer recognizes the
data as numbers.
 
Jim,
Hello for Washington State, USA
The first thought that comes to my mind would be to check
the Format setting for the cells that you want to change.
try a number setting in the format of the cells
good luck
 
Back
Top