I need to join 2 access databases. I have tried using dataAdapters and then filling 2 different datatables. Then I used the merge method to join the datatables. The problem I had with that is that it added extra rows when adding the 2nd datatable in. Would anybody happen to know how to get the 2 databases to add the columns without adding extra rows?
So far I have tried filling the datatables with dataAdapters and then used the merge method. I have also tried Linq which didn't quite work out like I was hoping. If you need any other information, please let me know. Thanks!