importing data from excel to SQL server real time

hi,
how can i take data from an Excel spread sheet and populate
a SQL-server database . I have 4-5 spread sheets which are
constantly updated real time. All updates,deletes,inserts in Excel
must be reflected in SQL server concurrently.
thanks
aparThe equivalent of SQL Server trigger in Excel can be handled with Worksheet_Change() event. So, write your vba to connect to SQL Server and update the changes.

Importing Data from Excel Sheets into SQL Server Database

Hi,

Would like some help on how do I go about coverting an Excel File with columns of info into my SQL Server Database. The excel file will be uploaded from a user from my web application. I completely have no idea on where to start so any form of help is much appreciated thanks.

bump|||bump|||

Any help at all? Just to get me headed in the right direction.

Importing data from Excel file w/ multiple Excel sheets

Hi,
I want to import an Excel file that has many Excel sheets within it. I need
to get this into an SQL database using the DTS. I have set the DTS task to
import the Excel sheet successfully, but I ONLY get the 1st sheet imported.
What have I forgotten? Can someone assist in getting all sheets to be
imported. I am sure all of you knwo what I mean when I say "all sheets"
imported. However, just in case . . . these are the sheets that have the tabs
at the bottom of the Excel sheet.
I appreciate any assistance rendered.
Thanks.
In SQL2000, you can use the DTS Import Export Wizard. Once you selected the
appropriate file you want to load, it will show all the sheets in the
workbook on the "Select Source Tables and Views". You would be able to edit
the destination name for the tables where the data will be loaded.
If the package is already created you can create the connections and select
the sheet you want in the "Transform Data Task"
"4pcd" wrote:

> Hi,
> I want to import an Excel file that has many Excel sheets within it. I need
> to get this into an SQL database using the DTS. I have set the DTS task to
> import the Excel sheet successfully, but I ONLY get the 1st sheet imported.
> What have I forgotten? Can someone assist in getting all sheets to be
> imported. I am sure all of you knwo what I mean when I say "all sheets"
> imported. However, just in case . . . these are the sheets that have the tabs
> at the bottom of the Excel sheet.
> I appreciate any assistance rendered.
> Thanks.

Importing data from Excel file w/ multiple Excel sheets

Hi,
I want to import an Excel file that has many Excel sheets within it. I need
to get this into an SQL database using the DTS. I have set the DTS task to
import the Excel sheet successfully, but I ONLY get the 1st sheet imported.
What have I forgotten? Can someone assist in getting all sheets to be
imported. I am sure all of you knwo what I mean when I say "all sheets"
imported. However, just in case . . . these are the sheets that have the tabs
at the bottom of the Excel sheet.
I appreciate any assistance rendered.
Thanks.In SQL2000, you can use the DTS Import Export Wizard. Once you selected the
appropriate file you want to load, it will show all the sheets in the
workbook on the "Select Source Tables and Views". You would be able to edit
the destination name for the tables where the data will be loaded.
If the package is already created you can create the connections and select
the sheet you want in the "Transform Data Task"
"4pcd" wrote:
> Hi,
> I want to import an Excel file that has many Excel sheets within it. I need
> to get this into an SQL database using the DTS. I have set the DTS task to
> import the Excel sheet successfully, but I ONLY get the 1st sheet imported.
> What have I forgotten? Can someone assist in getting all sheets to be
> imported. I am sure all of you knwo what I mean when I say "all sheets"
> imported. However, just in case . . . these are the sheets that have the tabs
> at the bottom of the Excel sheet.
> I appreciate any assistance rendered.
> Thanks.

Importing data from Excel file w/ multiple Excel sheets

Hi,
I want to import an Excel file that has many Excel sheets within it. I need
to get this into an SQL database using the DTS. I have set the DTS task to
import the Excel sheet successfully, but I ONLY get the 1st sheet imported.
What have I forgotten? Can someone assist in getting all sheets to be
imported. I am sure all of you knwo what I mean when I say "all sheets"
imported. However, just in case . . . these are the sheets that have the tab
s
at the bottom of the Excel sheet.
I appreciate any assistance rendered.
Thanks.In SQL2000, you can use the DTS Import Export Wizard. Once you selected the
appropriate file you want to load, it will show all the sheets in the
workbook on the "Select Source Tables and Views". You would be able to edit
the destination name for the tables where the data will be loaded.
If the package is already created you can create the connections and select
the sheet you want in the "Transform Data Task"
"4pcd" wrote:

> Hi,
> I want to import an Excel file that has many Excel sheets within it. I nee
d
> to get this into an SQL database using the DTS. I have set the DTS task to
> import the Excel sheet successfully, but I ONLY get the 1st sheet imported
.
> What have I forgotten? Can someone assist in getting all sheets to be
> imported. I am sure all of you knwo what I mean when I say "all sheets"
> imported. However, just in case . . . these are the sheets that have the t
abs
> at the bottom of the Excel sheet.
> I appreciate any assistance rendered.
> Thanks.