TechSpot

Excel 2000 Importing data from Access DB

By Michelle2
Jun 21, 2005
  1. Hello everyone.

    When I import data from an Access DB into excel format, the numbers field doesnt work so I cant for instance do a sum for total number of hours spent on a job.

    I can use the tick on seperate cells which enters the data to number, but this would take far too long. I have also tried to right click on the collum header and format cells to numbers but this also doesnt work.

    So my question is this. Is there an easy way to reformat the cell data to number, or for excel to do this automatically on import?

    Thank you
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...