Hoe to Transfer excel file data in SQL server

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

ss-457805 SSCertifiable Points: 5872 More actions · Answer 1

Is there a reason why you don't want to use SSIS or DTS?

akash.suryan Mr or Mrs. 500 Points: 533 More actions · Answer 2

Not any specific reason just want to know is there anyother way to transfer files

ss-457805 SSCertifiable Points: 5872 More actions · Answer 3

You can use the import Wizard in SSMS, by rt clicking on the database - Tasks - Import data.

NazerMohamed Mr or Mrs. 500 Points: 502 More actions · Answer 4

Mr or Mrs. 500

Points: 502

July 8, 2009 at 7:32 am

try OPENROWSET / bcp

NM

Gosta Munktell SSCertifiable Points: 6004 More actions · Answer 5

Is there anyone who can help me how to transfer the excel data into SQL server without using SSIS and DTS

You have to be more specific with your question. There are many ways to import data from Excel

to SQL Server. Try BOL.

//Gosta

Gosta Munktell SSCertifiable Points: 6004 More actions · Answer 6

Is there anyone who can help me how to transfer the excel data into SQL server without using SSIS and DTS

You have to be more specific with your question. There are many ways to import data from Excel

to SQL Server. Try BOL.

//Gosta

Gosta Munktell SSCertifiable Points: 6004 More actions · Answer 7

Is there anyone who can help me how to transfer the excel data into SQL server without using SSIS and DTS

You have to be more specific with your question. There are many ways to import data from Excel

to SQL Server. Try BOL.

//Gosta

Charles Barnhart-229428 SSC-Addicted Points: 435 More actions · Answer 8

OPENROWSET works amazingly well as long as you are not operating on 64bit platform.

Example:

INSERT INTO {some table} ({field list})

SELECT {field list} FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;IMEX=1;HDR=YES;Database={path and file name of .xls}', [Sheet1$])

The IMEX=1 renders as text only to handle columns with mixed values (numbers and text).