#1
|
|||
|
|||
Accessing a database from Excel
Hi there;
I have a huge data set in an excel spreadsheet that is used to create drive usage graphs and charts for a very large VM infrastructure. Currently I am using just one Excel spreadsheet to collect and display the data. The downside is that it is now 13 MB, so hosting on our SharePoint site and having our users access the graphs and charts that way, is pretty clunky. I was trying to separate out the chart and graph generation from the actual data collection. The graphs and charts use the offset feature to populate the data. If I have an excel spreadsheet that has charts and graphs in it and uses the offset feature to populate the data, can I draw from an access database instead? How do I link an excel spreadsheet to tables/queries in a database? thanks MW Last edited by melvwahl; 07-14-2017 at 01:40 PM. Reason: missed info |
#2
|
|||
|
|||
Hi,
I found this info. It may help you. https://stackoverflow.com/questions/...2010-using-vba If more help need come on back. |
Tags |
charts, data base, excel 2013 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Accessing Visual Basic on my 2010 copy of Excel | justphilip | Excel Programming | 2 | 02-15-2016 08:54 AM |
Connecting to an Oracle database using Excel | Officer_Bierschnitt | Excel Programming | 2 | 11-26-2015 03:31 AM |
Question about using Excel as a database | WMGetz | Excel | 5 | 05-13-2012 10:04 AM |
How to convert foxpro database to excel | KIM SOLIS | Excel | 0 | 10-20-2011 11:24 PM |
Excel Database | mtnguye9 | Excel | 1 | 11-26-2009 01:42 PM |