Working with SQL 2005 problem

Working with SQL 2005 problem

Hello Morgane,

Since you are using SQL server 2005 it is easy to import any type of file to a database engine. Just you have to follow a very few steps for doing this:

> By opening SQL server 2005 you will have a Object Explorer window in left side

> On that you will have a Databases folder where you can find your databases

> While right clicking on your database you can find "Tasks" in that you can pick Import Data

> It will display a SQL Server Import and Export wizard you have to click next button

> Then it will ask for your Data Source where you can choose your file type(eg: Excel,Access,etc) and the location of file to be uploaded

> Click on next button. It will ask for Destination,Server name and your database name.

> After hitting next button it will ask, do you want to copy all the data from uploading file or you want to write a query for selecting particular conditions

> On next you can give the table name by typing the name of a existing table or you can create a new table there

> After that in next window you can choose Execute immediately

> After that hit finish button

> It will show the progress and number of items transferred to your database