Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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?
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page