slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ADO General | New Thread

View: Search:

Author

Thread: How to import all Opportunity records into an existing Excel sheet, using VB and ADO?

Greg Gongola
Posts: 1

How to import all Opportunity records into an existing Excel sheet, using VB and ADO? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jun 09 4:17 PM

Ok, I'm inexperienced here, but have a simple need and hopefully this will help others that want to do something very simple...

I'm just looking to have an existing Excel spreadsheet pull in all Opportunity records from SalesLogix. Could someone provide the VB necessary (for Excel) to:

(A) Establish an ADO connection to SLX

and

(B) return all the Opportunity records/fields

(or something similar?)

Thanks!
Greg

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: How to import all Opportunity records into an existing Excel sheet, using VB and ADO? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jun 09 7:54 PM

You don't need VB to do so.

Within Excel you could Load data from External Datasources.
All you need to do is establish a DataSource to it using SQL or OLEDB Provider and then define your Query. (You may even get a "query builder" UI for defining the SQL statement).

After you have done so, you could always refresh that data as needed (you may even be able to set it up to auto refresh on open).

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 5:11:52 AM