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?