Results 1 to 3 of 3

Only 25 Excel rows export into my Access table.

  1. #1
    rickm4484 is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2018
    Posts
    6

    Only 25 Excel rows export into my Access table.

    Access 2016, Excel 2016, Window 8



    I'm having some trouble getting external data from an Excel file. I successfully transferred the Excel spreadsheet into my Access table the other day. But, wanted to make some changes to the data, so I made a copy of my Access db, eliminated a column in my Excel and tried to import/export again. I see 105 rows in my Excel file, but only 25 get transferred into my Access table. Tried it several times, but same result. Any idea what I'm doing wrong?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    43,831
    What method are you using? Post code and example data.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    rickm4484 is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2018
    Posts
    6
    June7, thanks for the quick reply, but I think I solved this. I noticed my Office365 Access saved my Excel file in Internet Explorer rather than .xls. I deleted the IE saves and selected the .xls file for import/export. All rows were transferred to Access.
    Thanks again!

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

Similar Threads

  1. Replies: 3
    Last Post: 04-07-2016, 03:36 AM
  2. Export Access table with two default header rows
    By ryonker in forum Import/Export Data
    Replies: 1
    Last Post: 07-07-2015, 03:17 PM
  3. importing multi- rows excel table into access
    By ahmed sami in forum Access
    Replies: 1
    Last Post: 10-28-2014, 12:08 PM
  4. Replies: 3
    Last Post: 08-02-2013, 02:46 PM
  5. Annoying error on macro export to excel - missing rows
    By Blueweasel in forum Import/Export Data
    Replies: 0
    Last Post: 12-15-2011, 03:41 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
  •  
Tech Forums: Microsoft Office Forums