Hi Judy
If you have VFP on the system that holds the Access data, you could use Access to start an ole session to VFP and squirt the data across to the table, but you will need to know what fields and types for the VFP table.
This is only a suggestion, I am sure other will supply other solutions.
Regards
Iain Brodie