In the old versions of Viaual basic (NOT VBA), the versions before .net, there was a serial comm. vbx plugin. You might be able to use it with Access depending on which version you use.
Otherwise there is a guy who made a 20$ shareware plugin to excel that allows excell to read data frm the serial port, it is here: