My company keeps their data on an ms access database, however, one of the companies they do business with will soon be sending us data via a dbase table.
So I've been asked to do 2 things. First, I need to read the data from this dbase table and update our access db with this new data and 2nd, I will also need to be able to do the opposite. That is I'll have to read data from our access db, place this data I've gathered into a dbase table, and send it off to this other company.
Oh, and both of these items must be able to each perform their task with a single click (in other words, I can't manually convert the dbase table into an access table. it must be fully automated).
So I guess my question is, Is there any way I can do this in an automated process? Does access allow you to read data from a single dbase table?
Thanks in advance.
-Goalie35
So I've been asked to do 2 things. First, I need to read the data from this dbase table and update our access db with this new data and 2nd, I will also need to be able to do the opposite. That is I'll have to read data from our access db, place this data I've gathered into a dbase table, and send it off to this other company.
Oh, and both of these items must be able to each perform their task with a single click (in other words, I can't manually convert the dbase table into an access table. it must be fully automated).
So I guess my question is, Is there any way I can do this in an automated process? Does access allow you to read data from a single dbase table?
Thanks in advance.
-Goalie35
