How to Import Data From Excel or Access To SQL Express

Question

1.00/5 (1 vote)

See more:

C#

C#4.0

plz anyone tell me how to import data frome excel or Access to SQL Express

Posted 4-Sep-11 6:56am

ankur dixit

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Uday P.Singh · Answer 1 · 2011-09-04T08:36:00

Solution 3

check these out:

Import Data to SQL Server from Excel or Access using TSQL Script[^]

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/546f4407-0aa4-4b04-96f3-e6f0ba39a9d1/[^]

http://support.microsoft.com/kb/237980[^]

hope it helps :)

Posted 4-Sep-11 8:36am

Uday P.Singh

Comments

RaviRanjanKr 4-Sep-11 15:03pm

Nice Links, My 5+

Uday P.Singh 5-Sep-11 1:31am

Thanks Ravi :)

Wendelius · Answer 2 · 2011-09-04T07:13:00

One way for both of these is to use Linked Server[^].

Basically you:
- define a linked server against the data source (Access, Excel etc)
- run a query to insert into Sql Server table based on a select on the linked server.

Some information about linking to Excel: http://support.microsoft.com/kb/306397[^]

Mehdi Gholam · Answer 3 · 2011-09-04T08:16:00

Solution 2

In case linked server is not supported in SQL express , there are data migration applications which copy tables and structures between different database types. Search for data migration in goggle and you will find them.

Posted 4-Sep-11 8:16am

Mehdi Gholam

RaviRanjanKr · Answer 4 · 2011-09-04T09:21:00

Have a look one of the great Library named FileHelpers library. there is an excellent article-[FileHelpers v2.0 - Delimited (CSV) or Fixed Data Import/Export Framework][^] in CP which will help you import just about any flat-file, CSV, and Excel with its all details.

Reference Link :- import csv file/excel into sql database[^] and Links Recommended by User-Marc_S[^]

You can also go for one of Other CP Reference is Import Data from Excel to SQL Server[^]

gmtzgtz · Answer 5 · 2011-10-13T14:11:00

Solution 5

You can use T-SQL, try this:

bulk insert [dbo].[Courses]
from 'C:\Courses.csv'
with (fieldterminator = ',', rowterminator = '\n')
go

For more info, check this post: Importing a CSV File into SQL Server

Posted 13-Oct-11 14:11pm

gmtzgtz