Hi All
The next stage of my college app.
I need to export data from an old access database, into SQL Server that my app uses
The data needs to be manipulated because it does not conform and the fields in the new database has changed.
What is the best method. I was thinking of reading data from Access, assigning the fields to a variable, manipulating it and then writing each record back to SQL Server.
It does seem long winded but the only way I know seen as I am new to C#.
I know how to write it back to SQL in C# but I must still figure out how to retrieve the data from access and assign it to variables.
is there a better method.
The next stage of my college app.
I need to export data from an old access database, into SQL Server that my app uses
The data needs to be manipulated because it does not conform and the fields in the new database has changed.
What is the best method. I was thinking of reading data from Access, assigning the fields to a variable, manipulating it and then writing each record back to SQL Server.
It does seem long winded but the only way I know seen as I am new to C#.
I know how to write it back to SQL in C# but I must still figure out how to retrieve the data from access and assign it to variables.
is there a better method.