Solved

visual studio import access database

Posted on 2006-07-05
4
1,259 Views
Last Modified: 2010-05-18
How do I import an access database into visual studio?
0
Comment
Question by:jackjohnson44
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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

829 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