Possible to send realtime data to an open Access or Excel table?

[Andrew Berghuis]

I have data from an external device that is currently sent via a
hyperterminal connection and which can be transferred to a txt file
afterwards. I would like to send the data directly to an open Access table or
Excel spreadsheet so that I can include other data to each record. Is this
possible?

 

[Arvin Meyer [MVP]]

I have data from an external device that is currently sent via a
hyperterminal connection and which can be transferred to a txt file
afterwards. I would like to send the data directly to an open Access table or
Excel spreadsheet so that I can include other data to each record. Is this
possible?

Yes. This is essentially what replication is designed to do. Since you can
link a text file as a table, you should be able to do what you want.
Replication requires some learning though, and here's a FAQ that may be of
help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;182886
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access