July 7, 2009 at 8:25 am
Hi ,
Is there anyone who can help me how to transfer the excel data into SQL server without using SSIS and DTS
Thanks in advance
July 7, 2009 at 8:29 am
Is there a reason why you don't want to use SSIS or DTS?
July 8, 2009 at 12:23 am
Not any specific reason just want to know is there anyother way to transfer files
July 8, 2009 at 4:53 am
You can use the import Wizard in SSMS, by rt clicking on the database - Tasks - Import data.
July 8, 2009 at 7:32 am
try OPENROWSET / bcp
NM
July 9, 2009 at 6:10 am
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
July 9, 2009 at 6:11 am
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
July 9, 2009 at 6:12 am
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
July 9, 2009 at 6:21 am
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).
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply