Using Sum for database data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sql query that imports data from a MySQL database.
When the data is brought into Excel I can't sum the numbers.
 
Without all of the details, I'm guessing that the SUM equates to zero.

If that is true, the values may be text that appear to be numbers. Try this
to correct the problem:

1)Put a 1 in a blank cell and select that cell
2)Edit>Copy
3)Select the imported values
4)Edit>Paste Special
--Select Multiply
--Select Values
Click the [OK] button.

Does that resolve the problem?
 
Thanks, I found that to work but I also realized that it is better to change
the structure of table in the MySql database. I used decimal instead of
varchar.

jn

Ron Coderre said:
Without all of the details, I'm guessing that the SUM equates to zero.

If that is true, the values may be text that appear to be numbers. Try this
to correct the problem:

1)Put a 1 in a blank cell and select that cell
2)Edit>Copy
3)Select the imported values
4)Edit>Paste Special
--Select Multiply
--Select Values
Click the [OK] button.

Does that resolve the problem?

--
Regards,
Ron


jnorton said:
I have a sql query that imports data from a MySQL database.
When the data is brought into Excel I can't sum the numbers.
Click to expand...
Click to expand...
 
I have a similar problem - MySQL returns the field type 'decimal' and Excel
2003 does not recognise it as numbers!. I obviously can create a column with
a formula "=Value(TheCellWithTheDecimalNumber)" - but I want to analyse the
data with a pivot table directly.

Any hints?

Rainer

jnorton said:
Thanks, I found that to work but I also realized that it is better to change
the structure of table in the MySql database. I used decimal instead of
varchar.

jn

Ron Coderre said:
Without all of the details, I'm guessing that the SUM equates to zero.

If that is true, the values may be text that appear to be numbers. Try this
to correct the problem:

1)Put a 1 in a blank cell and select that cell
2)Edit>Copy
3)Select the imported values
4)Edit>Paste Special
--Select Multiply
--Select Values
Click the [OK] button.

Does that resolve the problem?

--
Regards,
Ron


jnorton said:
I have a sql query that imports data from a MySQL database.
When the data is brought into Excel I can't sum the numbers.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel 2003, Microsoft Query - reference to subquery alias 1
SUM Function 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Excel reporting and database 1
How can I import data from a mysql database into excel 3
Access Access Report Works on One Machine but not Another 3
Numbers showing Up Centered in Cell ? 1

Back
Top