Results 1 to 2 of 2
  1. #1
    ravi_saka is offline Novice
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    1

    Question Unable to paste records from excel properly in MS-Access


    Hi all,
    I have a problem, I'm using Office-2007, when I tried to to paste data from Excel to Access some data is missing. The problem is, in excel I have a column "Employee id" whose text contains "Alphanumeric" say "A09008" and "701045". I have designed my MDB in Access for this column as "Text". Now, my excel records contains:

    dateEmployee IDEmployee Name11/15/2010806023rajrajjr11/15/2010705089rajar;aj11/15/2010756598ekei11/15/2010756598ij11/15/2010A07074ruio11/15/2010A07057ruiti11/15/2010A07010aljfui11/15/2010A00007poiur11/15/2010C09026abcuio11/15/2010907010rajr11/15/2010806070ra;jr11/15/2010806060rajrajjr

    If I paste this details in mdb:

    bug1ot_dateemployee_idEmployee_name11/15/2010806023rajrajjr11/15/2010705089rajar;aj11/15/2010756598ekei11/15/2010756598ij11/15/2010756504fasfsf fasdf11/15/2010756544rrue11/15/2010756505reurioue11/15/2010
    ruio11/15/2010
    ruiti11/15/2010
    aljfui11/15/2010
    poiur11/15/2010
    abcuio11/15/2010907010rajr11/15/2010806070ra;jr11/15/2010806060rajrajjr

    I am unable to view the employee ids "A07074","A07057","A07010","A00007","C09026"

    Can anybody solve my problem?

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Ensure the first record you paste contains an alphanumeric "Employee ID".

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

Similar Threads

  1. Replies: 2
    Last Post: 11-05-2010, 04:47 AM
  2. Replies: 26
    Last Post: 09-27-2010, 09:48 PM
  3. Paste Data From Excel To Access Form
    By fanzak in forum Programming
    Replies: 2
    Last Post: 08-16-2010, 02:40 PM
  4. Access 97: Unable to find project explorer?
    By captgnvr in forum Programming
    Replies: 0
    Last Post: 07-19-2010, 09:20 AM
  5. Combining multiple Excel records into Access
    By Jadey78 in forum Import/Export Data
    Replies: 0
    Last Post: 05-04-2010, 07:51 PM

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