473,372 Members | 928 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

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 1508

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

Similar topics

by: cooldv | last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and Access 2000 database. (with a hosting company) traffic is slow at this time but expect to grow. lately i have been reading...
by: Jegger | last post by:
Hello! We have following situation; network with 100 users, aplication developed in Access, user DB deployed on SQL Server. Is it better to create query inside aplication (with code) and then...
by: Mac MCCall | last post by:
I am doing work for a community that currently has four different MS-Access databases which are at four separate locations but have a great deal of overlapping data. There is a residents...
by: Daniel Manes | last post by:
Some facts: 1) I have an Access database (.mdb file) sitting on my harddrive. 2) I have Visual Studio 2005, Sql Server Express, and Sql Server Management Studio Express. 3) I do *not* have...
by: R.E.V. | last post by:
Hello I've seen a number of posts concerning the above type of conversion but have not been able to locate anything that gives a clear set of instructions to accomplish this. Here is my...
by: RayPower | last post by:
I'm having a system using Access 2000 as both front-end (queries, forms, reports & temp tables for reports) & back-end (data) with back-end running on the server. The application runs on the...
by: julietbrown | last post by:
I have been wandering through Google all day, getting lots of data but not much information! I have been developing what was originally seen as a single user Access db for a small charity. ...
by: coolminded | last post by:
dear all, i have two servers and my software is in one of those servers. both the servers have databases : db1 and db2. i tried the following query : select * from server2.db2.dbo.tblname ...
by: neelsfer | last post by:
My one application that deals with medicine records, may outgrow Access 2007 as a back-end in the next 6 months. I am now starting to think about the possible migration, but is totally out of my...
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.