copy access DataTable to existing Backup DataTable (append data)
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)
0
Did you use DataSet and datatables or connected mode