Hi there,

This is what I want to do. I've got a huge excel datasheet. I want to 

insert this data into my sqlserver database. This can't be done by DTS 

tool because I want to insert the rowdata into different tables and 

fields. Not all field in the SQl database can be filled so i've got to 

fill some of it with a empty field.

I can make a connection to the excel sheet in an ASP page but how do I 

insert this into the SQL database. Is it possible?



excel data

colum1, colum2, colum3 -> columnames are fields in SQL db

data1, data2, data3 -> fiels inserted into different SQl tables which are 

linked.



tia. 

Is this going to be a regular occurrence?



If it is just a one off, I'd just write a quick and nasty VB program or VBA

macro to do it.



If it is a regular thing, you might find that running excel is quite a hit

on your performance. Maybe encapsulate the code in a dll.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: odenijs [mailto:odenijs@h...]

Sent: Thursday, 20 September 2001 12:17 AM

To: ASP Databases

Subject: [asp_databases] excel into SQL Server





Hi there,

This is what I want to do. I've got a huge excel datasheet. I want to 

insert this data into my sqlserver database. This can't be done by DTS 

tool because I want to insert the rowdata into different tables and 

fields. Not all field in the SQl database can be filled so i've got to 

fill some of it with a empty field.

I can make a connection to the excel sheet in an ASP page but how do I 

insert this into the SQL database. Is it possible?



excel data

colum1, colum2, colum3 -> columnames are fields in SQL db

data1, data2, data3 -> fiels inserted into different SQl tables which are 

linked.



tia. 



 

Hi,

Its al regelar thing, cause we get all data in excel...so i have to make a 

conversion tool for it..

I have to do it in asp (vb ofcourse) because the software we are developping 

have to be made for our client. Client has to be able to convert an excel 

sheet into SQL server by himself. Maybe there's a conversion tool for 

conversion into Access db. Then its easier to use DTS tool...



Greetz







>From: David Cameron <dcameron@i...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] RE: excel into SQL Server

>Date: Thu, 20 Sep 2001 09:03:58 +1000

>

>Is this going to be a regular occurrence?

>

>If it is just a one off, I'd just write a quick and nasty VB program or VBA

>macro to do it.

>

>If it is a regular thing, you might find that running excel is quite a hit

>on your performance. Maybe encapsulate the code in a dll.

>

>regards

>David Cameron

>nOw.b2b

>dcameron@i...

>

>-----Original Message-----

>From: odenijs [mailto:odenijs@h...]

>Sent: Thursday, 20 September 2001 12:17 AM

>To: ASP Databases

>Subject: [asp_databases] excel into SQL Server

>

>

>Hi there,

>This is what I want to do. I've got a huge excel datasheet. I want to

>insert this data into my sqlserver database. This can't be done by DTS

>tool because I want to insert the rowdata into different tables and

>fields. Not all field in the SQl database can be filled so i've got to

>fill some of it with a empty field.

>I can make a connection to the excel sheet in an ASP page but how do I

>insert this into the SQL database. Is it possible?

>

>excel data

>colum1, colum2, colum3 -> columnames are fields in SQL db

>data1, data2, data3 -> fiels inserted into different SQl tables which are

>linked.

>

>tia.

>

>

>

Unless someone in the list has a better suggestion, create a vb program/dll

to shift the stuff across. How you execute it is another matter. If you call

it from ASP you will add a large hit to the performance of your server,

particularly if it is run often. You could run it as exe once a night,

scheduled or something like that. If it must be run more often than that

then  have a look at MSMQ. If you set up another box as a MSMQ server you

can run the dll out of procedure on another box, having little or no impact

on your server performance. I have no experience with running MSMQ, but I'm

sure it is documented.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: Okke de Nijs [mailto:odenijs@h...]

Sent: Thursday, 20 September 2001 5:52 PM

To: ASP Databases

Subject: [asp_databases] RE: excel into SQL Server





Hi,

Its al regelar thing, cause we get all data in excel...so i have to make a 

conversion tool for it..

I have to do it in asp (vb ofcourse) because the software we are developping



have to be made for our client. Client has to be able to convert an excel 

sheet into SQL server by himself. Maybe there's a conversion tool for 

conversion into Access db. Then its easier to use DTS tool...



Greetz