{{tag>category:"OpenInsight" author:"Tony Ayling"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Copy Records routine for ODBC connection (OpenInsight) ====
=== At 17 AUG 2001 04:56:45AM Tony Ayling wrote: ===
 
 
<QUOTE>
Greetings from OZ

I am hoping one of you colleagues can save me some time with a routine that copies data from an OI table to an ODBC table (MSSQL7) so that I can populate a clients table with OI data.

I need to validate and change certain data hence not warehousing.



Thanks in anticipation.

Regards

Tony Ayling

Brisbane
</QUOTE>

[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=19519587A001F00B85256AAB00312425|View this thread on the Works forum...]]