Learning ADO Conversion to Winbatch

Keywords: 	 ADO conversion  MDAC

---

Question:

i am looking to begin ADO data reporting to excel and need a begining point. are there any suggested "must reads" or points that have held others back that peeps could share? i dont know my arse from my elbow when doing any of this stuff. the fact the interpreter doesnt recognize the commands doesnt help either. i cant tell if what i type is a command or just jibba jabba. i took a look through some of the posts and for the most part, there is nothing that i understand. i want to have data from our hp ux/oracle database ported to excel. where do i begin? i think knowing what methods and properties are would be a fair start. what books do i need?

Answer:

MDAC is ADO (or it contains the ADO Objects). If you installed MDAC to its defaults, then under 'Program Files\Microsoft Data Access\Docs' there are help files for ADO and OLE - in the \inc subdir are ASCII files with all the ADO constants and numeric equivalents.

MDAC 2.6 has been released, it is free from Microsoft, and you can also get the MDAC SDK which is a super support piece.

To begin with try searching our tech support database for the keyword "ADO", you'll find some sample code.

---

Article ID:   W14915