none
Missing data when importing from excel RRS feed

  • Question

  • Hey guys, I need to copy over 2000+ records from an excel to ms access database. I tried importing and copy pasting, but it seems that fields with the "number entered as text" error in excel do not copy over. If i format the cells to number and enter each cell one at a time the error clears and imports fine, but I don't want to click through 2000+ cells. Is there a way to mass clear the error? I already tried disabling the function to check for errors - didn't work.
    Tuesday, August 20, 2019 2:18 PM

Answers

  • Access reads the first 20 rows to determine the data types. Make sure those rows contain numbers and Access should be able to recognize the rest of the rows as numbers.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by InnVis Tuesday, August 20, 2019 8:49 PM
    Tuesday, August 20, 2019 2:26 PM

All replies

  • Access reads the first 20 rows to determine the data types. Make sure those rows contain numbers and Access should be able to recognize the rest of the rows as numbers.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by InnVis Tuesday, August 20, 2019 8:49 PM
    Tuesday, August 20, 2019 2:26 PM
  • Thanks! This worked.
    Tuesday, August 20, 2019 8:49 PM
  • Glad I could help!

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, August 21, 2019 3:36 PM