copy access DataTable to existing Backup DataTable (append data)

Oct 7 2009 1:36 PM
I have an application which suppose to run to several computers. Once a week data from these computers have to bee added to central database (Microsoft Access), without overriding existing data. "Satelite" DataBases (and DataTables) have the same names like "central" database. I have tried to use: "SELECT * INTO Table1 IN 'c:\\MyDB.mdb' FROM Table1 IN 'd:\\MyDB.mdb'"; but it doesn't work. I got error "Table1 already exists" This is my first application, and my approach could be completely wrong, so I'm hoping that somebody has better idea.

Answers (1)