Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I get ALL of the rows copied in Excel into Access?

Discussion in 'Information Technology' started by Nate, Jul 28, 2006.

  1. Nate

    Nate
    Expand Collapse
    Guest

    When I copy 234 rows from Excel into Acess, only 229 records show up. I
    don't know which rows are not getting copied. I dealt with all the not
    enough space to copy into the field errors and it still doesn'y copy them
    all. Any ideas?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Profiled US Sikh Throws 'Know Me' Challenge Breaking News Jul 25, 2016
    Whats that pain between eyebrows when meditating? Questions and Answers Jun 23, 2014
    Canada Freeman movement grows across Canada Breaking News Sep 3, 2013
    Making Sparrows Hunt the Hawks Sikh Sikhi Sikhism Feb 21, 2013
    Pacific Religious Council Throws its Weight Behind Three Rallies Breaking News Jul 1, 2011

  3. jmonty

    jmonty
    Expand Collapse
    Guest

    This may happen for several reasons. Like for example, if the Access table is
    using a multiple field Primary Key and the Excel spreadsheet has 5 rows that
    are missing data in one of the key fields. This could happen if you are using
    a single field key as well - by the way.
    Or
    Maybe one of the Access database fields is Numeric and 5 rows in the
    spreadsheet contain Alphabetic data for that field (or visa-versa). Try
    sorting the Excel spreadsheet column by column. Ascending then descending.
    The problem data should rise to the top.

    If all else fails, change all of the fields in the Access table into Text
    fields, import all the data, then look for the 5 problem rows.

    jmonty


    "Nate" wrote:

    > When I copy 234 rows from Excel into Acess, only 229 records show up. I
    > don't know which rows are not getting copied. I dealt with all the not
    > enough space to copy into the field errors and it still doesn'y copy them
    > all. Any ideas?
     

Share This Page