Excel: Get External Data
You can connect Microsoft Excel directly to web and other databases such as Microsoft Access, Microsoft SQL Server, Oracle, and UBInfoSource. Refresh data on demand for your interactive reports and dashboards.
Related LibGuide: Computer Science by Jill Hackenberg
- Tuesday, November 27, 2018
- 9:00am - 4:00pm
- 310 Silverman
- North Campus
This workshop is designed to bring novice users to proficient on covered topics.
- Web Queries
- Open Database Connectivity (ODBC)
- Introduction to SQL and SQL Queries
This is the final session in a full week of data workshops given by internationally recognized experts presented by the University Libraries.
Workshops are offered at no charge to UB faculty, staff and students. All workshops in this series will be presented in room 310 of Capen
Hall inside Silverman Library. Bring your laptop, as this room is not equipped with workstations.
Co-sponsored by The Graduate School.