Copying MSSQL 2008 Data to MS Access
Posted on 2011-03-23
I have a MSSQL Database and would like to copy the data into a MS Access database. I tried using the MS SQL Studio Manager but in the middle of the process, I received an error truncation message.
The MS Access looks like it has all of the data in there but I did not know if there was something else that I could use? I had the hosting company do a complete backup if that matters. I also downloaded some Red Gate products but I don't know if one of them will work (if so, any ideas which one)?