Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1278
  • Last Modified:

visual studio import access database

How do I import an access database into visual studio?
0
jackjohnson44
Asked:
jackjohnson44
1 Solution
 
YZlatCommented:
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
 
jackjohnson44Author Commented:
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
 
orphicfireballCommented:
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
 
Bob LearnedCommented:
Access has an upsizing wizard.

Bob
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now