Wednesday, March 21, 2012

how can i mapped the sql data to the ms access db?

I need to create an ASP.Net page that connects to an MS SQL server as its
dbase. But the MS SQL server is really connecting to an MS Access db to get
the data.How can I mapped the data of the ms access db so that when my ms
sql server connects it can get the data and display the data in my ASP.net
page.
thanksHi
Is there a linked server created to communicate with Access database?
Please refer to the BOL (Linked servers) .
"cEciLlE" <cecille.regidor@.gmail.com> wrote in message
news:%23c8TSgiEFHA.3824@.TK2MSFTNGP10.phx.gbl...
> I need to create an ASP.Net page that connects to an MS SQL server as its
> dbase. But the MS SQL server is really connecting to an MS Access db to
get
> the data.How can I mapped the data of the ms access db so that when my ms
> sql server connects it can get the data and display the data in my ASP.net
> page.
> thanks
>

No comments:

Post a Comment