Friday, March 9, 2012

dts access to sql server express

How can I take an access database and import it into sql server express
the access db is on a different server then the sql server express.You could copy the Access file to the SQL Server computer before you start (which is what I'd recommend), or share the folder on the computer where the Access file is located and use a UNC path to reference the Access file (\\accesscomputer\sharename\accessfile.mdb).|||

http://blogs.msdn.com/sqlexpress/articles/616581.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB - SSMA a good one to go with this.

No comments:

Post a Comment