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
    8

    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 online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,538
    What method are you using? Post code and example data.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  3. #3
    rickm4484 is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2018
    Posts
    8
    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