Copy access database to MSSQL database?
I'm facing a problem what looked like vary easy to me but when I'm trying to solve it, it looks really problemetic.....
I have a access database and it contains more than 5000 records in it. Some of its rows are empty. Now I want to copy some of the selected columns of the database to a new MSSQL database without that empty rows using ASP.
But I'm getting "error '80020009' ." Can anyone tell me how can I transfer the records or solve the problem???
More Questions From This User See All
Answers & Comments
Verified answer
It's not going to be easy.
Start with this link:
http://www.microsoft.com/technet/prodtechnol/sbs/4...