Friday, March 23, 2012

Import from access db to sql express db

How do I import tables from an access db to sql Express?
reidarTHi
I did some testing on DEV edition and it works just file
SELECT *
FROM OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\northwind.mdb";
User ID=Admin;Password='
)...Customers
Take a look at linked servers in the BOL as well
"reidarT" <reidar@.eivon.no> wrote in message
news:%23S9JQgPoGHA.680@.TK2MSFTNGP03.phx.gbl...
> How do I import tables from an access db to sql Express?
> reidarT
>

No comments:

Post a Comment