|
For both products, ODBC is very easy to use, and part of the interface. In Access you import, using an ODBC source. For Excel, use MS Query to get data with ODBC. But the CA Excel addin is quite nifty - has what amounts to a wizard. I think there was a redbook once, but I couldn't find it at the site right now. Depending on how current you need to be, you could CPYTOIMPF and then map a network drive, having activated NetServer And there are ActiveX data objects that you could use in VBA. One article, "Using the Client Access for Windows 95/NT OCX Control and OLE Automation Objects with Visual Basic" <http://www-912.ibm.com/s_dir/slkbase.nsf/1ac66549a21402188625680b0002037e/def5574d27de318e862565c2007cbc3c?OpenDocument> still applies for the most part. Check VBA documentation for your version of Office. A search in the knowledge base for 'excel' brought up 30 documents, many of which apply here. A search on "ms access", exact match, found 5. "microsoft access", exact, found 9, including :Microsoft Access - Connecting to an ODBC Data Source" <http://www-912.ibm.com/s_dir/slkbase.nsf/1ac66549a21402188625680b0002037e/5b844866a567f4d6862565c2007cb515?OpenDocument> At 03:40 PM 6/14/02 -0400, you wrote: >Hello there again > Like to thank respondents on the CA problem I had, your > replies saved the day!. > I seem to be getting a great deal of requests, for > obtaing /400 data files in the > Windows office products, like Excel and Access. > Does anyone know of a paper or redbook that will help > with this task? > >Ken Shields >Oshawa systems group >Works 81, Oshawa Ontario >(905) 725-1144 Ext 326
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.