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 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!
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.