attn:Dave Pociu C/S Workspace (OpenInsight Specific)
At 12 JAN 1999 01:46:27PM Karl Lynn wrote:
Forgive me for being a rookie at this… ive only been using OI for about 5 hours now
Im not sure about how to take the data and use the C/S tool to move it into MS Access. Somebody sent me a bunch of data in AREV 3.1 and I took that data and brought it into OI. Now that I have the data in OI I want to send it to MS Access where I will do some manipulations..etc..etc.. Now when I go into C/S workspace and I try to set up a connection I double click on DataSource and I get a message saying there is no Data for ODBC or something of that sort. Any help would be greatly appreaciated.. again, sorry about bein a bit slow on the software but Ive only been using it for a short time. Again, thanks…
=Karl P.S. If you want, you could email me if its easier klynn@exitech.com
At 13 JAN 1999 12:13AM Dave Pociu wrote:
Karl,
I'm not exactly sure what the purpose of the exercise is:
1 - to do a one time move of AREV data to ACCESS
2 - to move data from an OI application that you have/will build to ACCESS on a regular basis.
If it's #1 then don't bother with OI as an intermediate step. Export from AREV in comma delimited format ( for example) and then import the data in ACCESS.
If it's #2 then you need to look in the knowledge base on this site for an article that describes how to declare the ACCESS ODBC drivers in win.ini for them to show up. You should also check out www.sprezzatura.com for an older newsletter ( called SENL) from summer 1998 ( I believe) that describes the detailed steps that you need to take in order to communicate between OI and ACCESS.