Exporting/Importing files into the SQL server tables

Exporting/Importing files into the SQL server tables

Hi,

Importing tables in the databases is not a difficult part of this process but importing tables with data, is something that needs more consideration and care when you are processing. I suggest you perform the tasks one by one and let me know if the problem is still there.

1: Open SQL

2: Select the Database in which you want to import the data.

3: Right click on any table of the selected database.

4: Click on “All Tasks”.

5: Select “Import Data”.

6: Click “Next”.

7: In Data Source select “Microsoft OLE DB Provider for SQL Server” from the drop down list.

8: In “Server” select “Local” or your target server.

9: If you are using windows authentication then select “Use windows authentication”.

10: Otherwise select “Use SQL Server authentication” and give SQL username and password.

11: In Database Select the database from which you want to import the tables with data.

12: Press “Next’.

13: In Destination process, select the Data Source, Server, and Authentication Mode as described earlier.

14: In Database Select the database to which you want to import the tables with data.

15: Select “Copy Tables and views from the source database” option.

16: Press “Next” button.

17: Select the table(s) from the list of the tables and views of source database.

18: Press “Next” button.

19: Press “Finish” button.

20: Press Refresh button given on the SQL panel or select it from the file menu.

After this you can checkout that tables are imported with data as well.