I need help BAD on loading data into a sql express DB from an access DB or mssql 2005 db
I created a project in vb express added a data source (Local to the project), created tables just like the walk through said and everything is good. The problem is I have all my data in an access DB and I don't want ot re-enter the data (much data). How can I get the data from the .mdb to the .sdf. I have tried Microsoft SQL Server Migration Assistant for Access but no luck. I was able to get the data into a ms sql 2005(the free one) .mdf database but not to the .sdf. I can get the data from either place (the mdf or the mdb) if I someone could tell me how.
Any help would be greatly appricated and I will be in your debt forever.
TIA
Cozmo
PS I would use the mdf database in my project but I can not get the thing to update or insert or delete records in the mdf. I copied it local but it wtill will not work. Set the "copy if new" option but it will not keep the changes. It acts like it will but when I shut down the project and reopen all the changes, inserts etc. are gone. If someone knows about this that would be as good as the answer to the one above.
CZ
