Recent content by avisam

Thank you. I saw that I tried to use PasteAsValues before and replaced it with PasteAll because I have some columns with numeric data that should be recognized as text (like: "004433"). In PasteAsValues excel recognize these columns as numbers. I will try your additional methods. Thank you...

Hello, I am copying a range from excel (multiple rows) and paste it directly to access table using: DoCmd.RunCommand acCmdPasteAppend Sometimes it does not work and I need to use paste special as text. Is there any way to paste special as text using VBA ? Thank you

Hello, Thank you for your answer. I am looking for SQL solution to my problem. Thank you for your help

Hello, I think it is more complected. I need to list for each employee - If he start a certification (cer sub 1 & 2 & 3 combination) but did not finished all cer name under it, list all registartions for cer sub 1,2,3 combination and add missing registrations. I know how to it using code: 1...

Hello, I have one table with certification data: cer ID, cer sub 3, cer sub 2, cer sub 1, cer name for the combination cer sub 3 & cer sub 2 & cer sub 1 there are multiple certifications names for example: cer sub 3, cer sub 2, cer sub 1, certification name 1 cer sub 3, cer sub 2, cer sub 1...