rtd to access

[Dan]

I have an Excel sheet that get data via rtd (every day new data) , this sheet
became too big, how can I get the data via rtd directly to an access table.
Thanks
Dan

 

[Jerry Whittle]

What is "rtd"?

 

[Dan]

RTD Retrieves real-time data from a program that supports COM automation

http://office.microsoft.com/en-gb/excel/HP030662371033.aspx