Hi! I have streaming data coming into excel file. I want to copy it every second and compile in another excel file which will be linked to an Access database.
Is there a way to add the data to the second file and process this live data in Access?
Hi! I have streaming data coming into excel file. I want to copy it every second and compile in another excel file which will be linked to an Access database.
Is there a way to add the data to the second file and process this live data in Access?
Post your question here .
http://www.excelforum.com/access-tables-and-databases/
Thanks...But I have no issues in compilation / linking the file to Access. My problem is if I keep Access database open, the compilation in excel is affected ( file is opened as Read Only and can't be saved). If I close Access Database the compilation in excel happens without any problem. I need to compile the streaming data every second and also need to analyse it at the same time.
Is there a way to run the macro in the background while allowing you to work on the file?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks