We help IT Professionals succeed at work.

Import Access DB or Tables into SQL SERVER 2005

208 Views
Last Modified: 2013-11-05
I am a newbie to SQL Server 2005.  I have limited experience with Tansact SQL, and no experience with SQL 2005.  I want to explore SQL 2005 with my data in some of my Acces DBs.  How can I quickly import Access tables or DB into SQL Server 2005.  If there is a link to somewhere that will explain, that works for me.
Comment
Watch Question

A quick and dirty way is the MS Access Upsizing Wizard
What version of MS Access are you using?
Most Valuable Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Tools | Database Utilities | Upsizing Wizard

Author

Commented:
Thanks to the two of you for responding.  I used Jim's method.
Most Valuable Expert 2014

Commented:
Glad to be of assistance. May all your days get brighter and brighter.

Just a side note on either method: SQL will generally create the text fields as NVarchar instead of Varchar. If you are using only English as your language, you may want to re-develop/edit the data types to be Varchar. NVarchar is the Unicode version  and uses twice the space for the same amount of data.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.