TechSpot

Excel 2000 Importing data from Access DB

By Michelle2
Jun 21, 2005
Topic Status:
Not open for further replies.
  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.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.