none
Trouble importing Excel Data RRS feed

  • Question

  • I have a access 2013 DB.  I am trying to import a Excel Spreadsheet into a new table in the db.  I havedone this many times in the past.

    when I run the  import, (Click finish) I get the error displayed below.  I have never seen this before.  what does it mean?

    • Edited by tkosel Saturday, September 17, 2016 10:29 PM
    Saturday, September 17, 2016 10:27 PM

Answers

  • Look more carefully - there is a space before the word "German"! Please remove that space from the column header in the worksheet, then try to import it again.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by tkosel Sunday, September 18, 2016 3:00 PM
    Sunday, September 18, 2016 8:40 AM

All replies

  • Make sure that the field names (column headers) of the Excel sheet are unique, that they don't contain "special" characters, that they don't begin with a space, and that they aren't empty.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Saturday, September 17, 2016 11:43 PM
  • Hans,

    Thanks for your immediate response again.

    The field names ARE unique, there are no special characters and they don't begin with a space and they are not empty.

    I have copied the top row of the excel spreadsheet (Field Names) and pasted it below.

    REFNUMBER Description Colors English  German Spanish French Italian Portugese Dutch Danish Swedish Norwegian Finnish Polish Greek Chinese Korean Russian Turkish

    Saturday, September 17, 2016 11:58 PM
  • Look more carefully - there is a space before the word "German"! Please remove that space from the column header in the worksheet, then try to import it again.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by tkosel Sunday, September 18, 2016 3:00 PM
    Sunday, September 18, 2016 8:40 AM
  • Look more carefully - there is a space before the word "German"! Please remove that space from the column header in the worksheet, then try to import it again.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Hans, how did you ever catch that from the data I posted?  Did you use a Hex editor?  You wee as usual right.  I need to be more careful!  Thanks.

    One other not related issue that I just noticed.  I turn warnings on and off using vbcode  when I run queries.  However, not even if I turn them on using code before I run them, they don't activate.  I cannot get them to work.  They don't run when I manually run a query either.  I cannot find where to turn them on or off in options either.  Sometime I like them to run!  Can you help me get them turned back on?

    Sunday, September 18, 2016 3:41 PM
  • I pasted the row from your post into Word, and displayed non-printing characters (Ctrl+Shift+8).

    Warnings are only displayed for action queries, i.e. make-table queries, append queries, delete queries and update queries, not for select queries.

    The setting for the warnings can be found in File > Options > Client Settings > Confirm (under Editing):


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, September 18, 2016 4:09 PM