my company has asked me to create a continously updating excel document. we use a program that creates a log file in a csv format that is updated about every 3 to 5 minutes. As you can guess this makes for a very large file in a very short time. what they want is to be able to access the data in the log via excel. they also want the data to be imported into an access database every night and have the log file reset so that its size doesnt get to large, and to have this archived data available to. but they want the current days data as close to real time as possible. is their a way to create a single document that can be accessed by everyone to show this data in realtime in excel or access?
Bookmarks