SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 IMPORTING EXCEL DATA TO AN ALREADY EXISTING DB
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sonia_newbie
Starting Member

India
17 Posts

Posted - 11/01/2012 :  10:45:39  Show Profile  Reply with Quote
Hi All,
I have a query related to sql.

I have an already existing database.Now I have to add another table to the database but i don't have a code for importing the data.Is it possible for me to import a data from an excel sheet to a table to a db without a code.
Please let me know what should I do.
Should i create a new table name with columns?
How should i import the excel sheet data?

I work on unix.

sonia_newbie
Starting Member

India
17 Posts

Posted - 11/01/2012 :  11:01:58  Show Profile  Reply with Quote
Just to add on ..
my excel sheet looks like this

name start_location end_location details
milguel 2345 5678 parathesis
vanise 3433 4544 quantified.
............

i need to import this excelsheet data to my db.(only the columns : name and details to my db.)
I will have to create a table named details in my database with 2 columns namely : name and details. Am I right?

can i create a table and column in my db without mentioning the datatype ?

Also how can i import those two columns from the excelsheet to my table without a code? Do i need some tool or software?
Thanks in advance.Sorry fro multiple posts!
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 11/01/2012 :  11:19:29  Show Profile  Reply with Quote
You should be able to use Import/Export Wizard. Right click on the database name in object explorer in SQL Sever Management Studio, select Tasks->Import Data and follow through the wizard. The wizard will give you options to pick and choose the columns you want to import, create a new table or use an existing table, decide whether to wipe out the existing data in the table or not etc.
Go to Top of Page

clinton_eg
Yak Posting Veteran

India
60 Posts

Posted - 11/01/2012 :  12:39:26  Show Profile  Reply with Quote
Hello Sonia

You could try creating a SQL Server Integration Services package to transfer the required Excel data into the SQL database table.

Ewan Gilby
Go to Top of Page

sonia_newbie
Starting Member

India
17 Posts

Posted - 11/04/2012 :  21:10:45  Show Profile  Reply with Quote
Thanks all!!!
It worked :)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000