[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Insert Text Values

Posted on 2009-04-27
1
Medium Priority
?
154 Views
Last Modified: 2013-12-17
I have an acess table that I want to inset into SQL Server 2008.

Is there anyway I can do this?
0
Comment
Question by:Brogrim
1 Comment
 
LVL 18

Accepted Solution

by:
DarrenD earned 2000 total points
ID: 24240612
Hi,

Yes, you can just use the Import Wizard and import the tables you want into SQL Server?

Goto SQL Server and create a new database. Then right click and choose Import...

You should be able to import any table from an access database.

Cheers,

Darren
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

872 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