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....

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....

Instead of doing everything in T-SQL you can create an Excel macro in VBA.

I include a small example to work on.

Sub test

Dim con As New ADODB.Connection 'Set reference...

It is easy to automate an Excel macro.

Put the macro (call to) in the sub "Private sub open Workbook_open"

Set securitylevel so the nacro will run without user interference.

Scedule the excelfile...

"We need to gather data from two Oracle database, two SQL 2005 database, and about eight Excel workbooks into a single SQL database. This process will be scheduled to run...

I think that you still can use Excel.

What is your source? If it is a lot of code to maintain may be you shall do more

in the source SQL server?...

I don't know if there is any difference between SQL Servwer 2005 and 2008 but

there is no problem running 2005 with VB6 ADO and ODBC (SQL Server). I do this...

If you are new to SSIS the question is if you will do more than just import flat files else I would

recommend you to use bulkinsert instaed . ...

I would recommend that you save the Excelsheet(s) as tab separated textfiles and use bulkinsert instead.

/gosta

This is an Excelproblem.

I dont use DTS. To control the behaviour of Excel the best way is to use VBA in Excel

and import a recordset from the database.

/Gosta

Josephptran2002

You are not the only one having problems to import data from Excel (xls) to SQL-server.

This has been on the agenda in this forum many times.

I always save the Excelsheet...

Steve

I feel with you as I know what pain means.

I have been active all my life with sports like jogging etc but

I got leg and back pain a year ago....

"I was using the VB application since it made the parsing and loading process very low maintenance. The downside is that as my needs have increased, the performance is lacking.

I...

Vika

I would do as Jack recommends. Working with SSIS and Excel is not that easy (

look at the questions in this forum).

You can do it in Excel with VBA but...

Dave

I use

SELECT * FROM openrowset('MSDASQL', 'Driver={PostgreSQL UNICODE};Database=xxxx;Server=yyyyy;

uid=xxxx;pwd=zzz','SELECT something FROM table')

in a stored procedure run to a remote Postgreserver. This works like a dream.

The login on The SQL-server 2005 is...