I have huge data in excel form. To access through intranet by giving key data I need a program

6th Feb 2017, 12:03 PM
sowmi - avatar
2 Answers
+ 5
first thing i would do if it does indeed contain a huge amount of data is to get it out of excel quick smart. Excel is *not* a database. Your problem will most likely resolve itself after this first step. http://adminsecret.monster.com/benefits/articles/2599-excel-is-not-a-database
6th Feb 2017, 12:12 PM
jay - avatar
+ 2
@jay thank you. @sowmi: It is extremely rare that Excel *really* needs to be automated to work with data...and in those cases you'd probably just generate one from the database (or use the database as a data source). Microsoft gives you SQL Server Express for free, and there's MySQL, MySQL Workbench, etc...
6th Feb 2017, 5:07 PM
Kirk Schafer
Kirk Schafer - avatar