Updating Access Database W/ SQL Commands

[adalton11]

Is there a way that i can update a database on "PC A" with data from a database on "PC B."

 

All i want is 1 table, the fields match, but the other tables don't. Therefore if i copy the whole database, it will get corrupted.

 

 

Thanks,

Anthony

[jspencer]

The best way might be to use a programatic import from within Access on PC B. You can truncate the table then run the dbimport command (although I can't remember how it goes - Access is a distant memory now).