How to import data from Excel to SQL Server

How to import data from Excel to SQL Server

Introduction

In this article you will see how to use the SQL Server import an MS Excel file on your computer to a database on your SQL Server.


Open The Sql Query window select the database and Type

create database samp

go

sp_configure 'show advanced options',1 

reconfigure with override 

go 

sp_configure 'Ad Hoc Distributed Queries',1 

reconfigure with override 

go

SELECT * into temptable

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

                'Excel 8.0;DATABASE=C:\Users\RAJU\Desktop\pincodes.xls;IMEX=1',

                'SELECT * FROM [Sheet1$]')

select * from temptable

Change the English text entered in textbox to other language using C#/ASP.Net

Change the English text entered in textbox to other language using C#/ASP.Net, jquery !

Introduction

 

In this article I will explain how to Change the English text entered in textbox to other language using Google Api in asp.net.

 

 

Description:

 

 

 Now I will explain In this article I will explain how to Change the English text entered in textbox to other language using Google Api in asp.net. To implement this one we need to write the code as shown below

English text entered in textbox to other language
English
English to Tamil
English to Hindi
English to Kannada
English to MARATHI
English to MALAYALAM
English to GUJARATI
English to TELUGU