Results 1 to 2 of 2
  1. #1
    njx is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    2

    Import Excel into Access database

    hi


    new to Access and trying to import an Excel sheet into Access but when i do i get Field F15 doesn't exist in destination table
    my excel sheet has column names in row 1 and the data for import in the following rows
    i don't have any illegal characters, my database has 14 named fields only and lines up exactly with the excel sheet
    what am i doing wrong?

    nj

  2. #2
    njx is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    2
    hi
    solved it... turns out i was using a word in the column heading that wasn't allowed for access!

    nj

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import data from excel to Access Database
    By n2d2cool in forum Access
    Replies: 1
    Last Post: 12-13-2016, 05:02 AM
  2. Import Access Database into Excel in Multi-User Environment
    By Chim20 in forum Import/Export Data
    Replies: 7
    Last Post: 10-06-2016, 02:23 PM
  3. Replies: 5
    Last Post: 10-27-2015, 06:00 AM
  4. Replies: 2
    Last Post: 12-26-2012, 02:58 PM
  5. Replies: 1
    Last Post: 01-23-2012, 11:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums