none
Run Time Error '2391.' Field "F31" not in destination table

    Question

  • i facing this error in access database when i try to import excel file to it, the acxel have 3 sheets and the error in the first sheet

    when i make debag it give me this line that have the error

     DoCmd.TransferSpreadsheet acImport, 8, "CourseSched", myfile, True, "Course Schedule!" & "A1:EZ65000"

    i really need help in this one


    Thanks for any help :) my blog is: http://www.waelk.com
    Monday, May 24, 2010 7:24 AM

Answers

  • thanks it was solved the problem was formated of excel sheet
    Thanks for any help :) my blog is: http://www.waelk.com
    • Marked as answer by wael_e Saturday, May 29, 2010 5:20 AM
    Saturday, May 29, 2010 5:20 AM

All replies

  • You are importing a spreadsheet in a table and field31 from the excel file is defined in your table. So look in your accesstable and add field 31 to the table. After you've done so try the import again and have a look at what field31 really is.

    Notice: A1:EZ65000 is a lot of rows, do you really have all data there?

    Maurice

    Monday, May 24, 2010 10:43 AM
  • thanks it was solved the problem was formated of excel sheet
    Thanks for any help :) my blog is: http://www.waelk.com
    • Marked as answer by wael_e Saturday, May 29, 2010 5:20 AM
    Saturday, May 29, 2010 5:20 AM