Wise Owl Answers - How do I find the data type of a column in an ADODB recordset?

[@pannerselvammaruthachalam825]

Wonderful video great teacher

[@WiseOwlTutorials]

Thank you so much Panner! I appreciate your support!

[@youssefsedkey7616]

Andy ... you make it as a piece of cake. thanks a lot.

[@WiseOwlTutorials]

Thank you Youssef!

[@krn14242]

Thanks Andrew. Great video and clean way to format the data.

[@WiseOwlTutorials]

Cheers Kevin, glad you enjoyed it!

[@bbmmwwcc]

Truly great help! I have been searching hours for a solution. This one definitely the best.

[@WiseOwlTutorials]

Thanks, happy to hear that it helped!

[@xaviruiz8345]

I really like the way you explain in your videos:)

[@WiseOwlTutorials]

Thank you Xavi, I appreciate the kind words!

[@yasminalsham5619]

Bunch of thanks Sir, very helpful as usual.

[@WiseOwlTutorials]

Happy to hear that it was useful for you Yasmin! Thank you for watching and for taking the time to leave a comment!

[@RohithKK-uh7pp]

Sir, very informative and excellent. I enjoyed it. Thank you.

[@WiseOwlTutorials]

My pleasure Rohith, thank you for your support!

[@donbogdala5428]

Outstanding Tutorial! Can't wait for the next!

[@WiseOwlTutorials]

Don! Fantastic to see you man! Glad you enjoyed that one, more on the way!

[@thwbn3993]

as always: very clear and useful! thanks a ton!

[@WiseOwlTutorials]

My pleasure, happy to hear you enjoyed it!

[@aNDy-qh1em]

Thank you, well done! When there is a need to copy similar report from rs, i prefer to add a workbook(xlWBATWorksheet) in a newly created instance of excel application rather than adding sheet to the existing wb.

[@WiseOwlTutorials]

Cheers that's a good tip, thanks for sharing!

[@aNDy-qh1em]

@@WiseOwlTutorials You are welcome. I never tested but if there is still a need to copy to a sheet in the same wb, maybe it worth trying to copy to an array from rs followed by copying from the array to a range -in order to bypass the above mentioned bug. Data types will be lost while first copying to an array of variant - so we will need to capture 'em from first rs data row. Again, i am not sure if this will work but at least i would try this option as there is no looping involved.

[@WiseOwlTutorials]

Indeed, that's a good way around it! I guess I was just curious about what's going on inside the CopyFromRecordset method which causes this behaviour in the first place. And, more importantly, why it hasn't been fixed after at least 10 years!

[@VillaOuk]

Thank you. It's a great tutorial.

[@WiseOwlTutorials]

You're very welcome Villa! Thank you for watching!

[@frikduplessis8849]

As usual a stunning tutorial Andrew, unfortunately I can't help you with the format problem, however my code is so insufficient and slow maybe that's the answer 😀, I'm connecting to a file from our lab department why is it actually opening?

[@WiseOwlTutorials]

Thanks Frik! I'm not sure that anyone can help with the format problem but I'm definitely curious to see if other people experience the same. Perhaps we should all buy old computers to avoid the problem!

[@PankajNegi007]

Thanks for sharing very informative video. Sir i made Data entry form in excel sheet as per your watching videos where multiple person works same time and data save in sql server. Now i need some help that in data entry form there is comment box where we can enter any type data now when they type ' or special character so update query show error how to fix this erros. What is the solution of this type error?

[@yasminalsham5619]

I would like to ask please, I tried to get Sum of some columns with Where statement. And get unique values of columns some columns using SELECT DISTINCT. it's working fine, but to my surprise, the code gives error when the number of records for the table is getting 70k record and more. it's giving an error message. do you Sir, have the same problem? appreciate you answer Regards

[@WiseOwlTutorials]

Hi Yasmin! Can you tell me what the error message says and which line of code causes the error?

[@minitv3447]

Thanks a lot sir, Need help? Want to set password in access database using excel vba I have created the database and table using vba but can't set the password Can you help me on this Using office 365

[@WiseOwlTutorials]

Sorry I don't know the answer to that question.