MartyConnelly
martyconnelly at shaw.ca
Wed Jan 25 15:33:44 CST 2006
This might help too. ADO Data Type mapping Table between Visual Basic, Access, SQL Server, Oracle, http://www.carlprothman.net/Technology/DataTypeMapping/tabid/97/Default.aspx And you might look at acquiring TOAD for Oracle, the IT guys might appreciate it. http://www.quest.com/toad/app_sqldeveloper.asp Tesiny, Ed wrote: >To access our agency's data we have to use this %$#@& Oracle tool called >Discoverer. Could one access Oracle tables using Access as a front end >through an ODBC connection. If so, would it be a big deal to set this >up. The last time I asked, the IT answer was we can't do that. Never >got a why we can't do that??? Anyway, that person is now gone and I'm >wondering if I should give it another try. >Any thoughts/advice appreciated. >Ed > >Edward P. Tesiny >Assistant Director for Evaluation >Bureau of Evaluation and Practice Improvement >New York State OASAS >1450 Western Ave. >Albany, New York 12203-3526 >Phone: (518) 485-7189 >Fax: (518) 485-5769 >Email: EdTesiny at oasas.state.ny.us > >_______________________________________________ >dba-Tech mailing list >dba-Tech at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-tech >Website: http://www.databaseadvisors.com > > > > -- Marty Connelly Victoria, B.C. Canada