Solved

visual studio import access database

Posted on 2006-07-05
4
1,260 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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