How can I move information from paradox database to access database in vb.NET?
Can anyone tell me how can I move information from paradox database to access database in vb.NET?
In vb form I have a listview where is all id numbers and names that are in paradox database. I choose some of those id number rows that I want to move to access database. I don't want to move all of them. I should get all information from paradox tables where the id number is same that I choosed. :confused:
Re: How can I move information from paradox database to access database in vb.NET?
The brute-force way would be to load your desired records into a DataTable, and then loop through those records, executing a SQL "INSERT INTO" statement to put the data into your destination database.
The more elegant, ".NET" way, would be to create two Datasets, copy the data from one to the other, and then use the Dataset's .Update method to write the records to disk.
It's not the sort of task that lends itself to an easy "data-binding" solution.
More to the point, you're probably better off moving all of your data. You should be able to import the Paradox tables you need into Access. You'd save yourself a lot of time and effort, I should think.