sql server 2008 export to mdb issue
- by Vivek Chandraprakash
Hi
i'm trying to import records from a mdb file to sql server 2008. i have a separate db server and application server.
wrote a stored proc to import data from mdb. But it fails as the mdb is on a network. It works if it's on the db server itself.
i'm using sql server account.
if i login using windows account and try the same sp it works.
How to make it work for sql server account?
-Vivek