Solved

visual studio import access database

Posted on 2006-07-05
4
1,266 Views
Last Modified: 2010-05-18
How do I import an access database into visual studio?
0
Comment
Question by:jackjohnson44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 35

Expert Comment

by:YZlat
ID: 17044884
what do you mean by importing access data to visual studio? do you just want to display data?

or do you want to take data from somewhere and import it into access?
0
 

Author Comment

by:jackjohnson44
ID: 17044911
I want to start using sql server 2005 which came with visual studio.
I don't want to use access any more, but want to import or copy the at least the table structure.

In the old enterprise manager, you could click on a database, select import and use a wizard.

Is there any way to do this with visual studio 2005?

I have been using vb6 for a long time, I want to practice with vb.net.
0
 
LVL 2

Accepted Solution

by:
orphicfireball earned 500 total points
ID: 17051722
The DTS Wizard that comes with SQL Server can do this.  You should be able to find it here:

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

It can migrate all kinds of databases.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 17055194
Access has an upsizing wizard.

Bob
0

Featured Post

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question