469,127 Members | 1,349 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

How do i access tables exported from access into SQL Server Express

I am an absolute novice when it comes to the world of SQL and SQL Server Express. I downloaded from Microsoft & ran executeables for SQLEXPRWT_x86_ENU, SQLEXPR32_x86_ENU & SQLManagementStudio_x86_ENU. I open SQL server 2014 import and export data. I select the source type, Microsoft Access Database Engine & select my access database. For Destination I select SQL Server Native Client 11.0 and enter a new database name, next. I choose Copy data from 1 or more tables, select a table, all is good. SElect finish, all is green, The Execution was Successful shows. Here's the part I don't get. where do I go to see that table? In Windows Explorer, I see the destination database name with 2 extensions, .mdf & .ldf. I opened up SQL server 2014 Management Studio, tried open or connect to the DBs, but I don't see a way to access them. What am I missing here? Is there another SQL EXPRESS program that I need to download? This is for testing purposes just on my pc. We have access tables with large numbers of records and want to look at writing queries & development tools. Thank you.
Nov 4 '15 #1
0 1412

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Jegger | last post: by
reply views Thread by Mac MCCall | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.