473,386 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Excel file data import to Sql server 2000 via the asp.net

Hi,

I joined a project where we need to import data from a excel file into
sql server via the asp.net.

After doing a long research found that
#1. Upload Excel file to the server
#2. Load or keep the Excel file into the memory
#3. Query the excel file and convert into insert queries and execute
them via sql server
or
write a DTS package and use it via asp.net

Where can I find more information,
- Which is the best approach and what are adv. and dis-adv.
- How to set the properties of DTS package via asp.net

Any other related links are a good help.

Regards,

Sreedhar Vankayala
Nov 18 '05 #1
2 12693
if you are using xp excel, then try Office XP Inerop Assemblies released by microsoft which help you avoid installing MS excel on the server.

for loading the data into SQL, I'd prefer to batch the data into SQL directly without creating any DTS. Just load the data into a dataAdapter and then batch it as a whole into SQL.

this may help you http://msdn.microsoft.com/library/en...asp?frame=true
hope this would help you.

--
Sarmad Aljazrawi
B.Sc. Computer Science, MSDBA, MCP
www.aljazrawi.net
"Sreedhar Vankayala" <va*****@yahoo.com> wrote in message news:7b**************************@posting.google.c om...
Hi,

I joined a project where we need to import data from a excel file into
sql server via the asp.net.

After doing a long research found that
#1. Upload Excel file to the server
#2. Load or keep the Excel file into the memory
#3. Query the excel file and convert into insert queries and execute
them via sql server
or
write a DTS package and use it via asp.net

Where can I find more information,
- Which is the best approach and what are adv. and dis-adv.
- How to set the properties of DTS package via asp.net

Any other related links are a good help.

Regards,

Sreedhar Vankayala

Nov 18 '05 #2
Cool. Thanks for the reply and working towards the steps mentioned ...

I have lot of macros in the excel sheet. Currently, I am working on
how to get the data.

Reg. the assemblies, would it cover all the functionality like getting
data out of sheet which has complicated macros ?

Link provided is 2001, wondering if there is a better way in the new
ADO.net, as of today ?

- Sreedhar
"Sarmad Aljazrawi" <anonymous[shylme]@discussions.microsoft.com> wrote in message news:<#6**************@TK2MSFTNGP10.phx.gbl>...
if you are using xp excel, then try Office XP Inerop Assemblies released
by microsoft which help you avoid installing MS excel on the server.

for loading the data into SQL, I'd prefer to batch the data into SQL
directly without creating any DTS. Just load the data into a dataAdapter
and then batch it as a whole into SQL.

this may help you
http://msdn.microsoft.com/library/en...82001.asp?fram
e=true
hope this would help you.

--
Sarmad Aljazrawi
B.Sc. Computer Science, MSDBA, MCP
www.aljazrawi.net
"Sreedhar Vankayala" <va*****@yahoo.com> wrote in message
news:7b**************************@posting.google.c om...
Hi,

I joined a project where we need to import data from a excel file into
sql server via the asp.net.

After doing a long research found that
#1. Upload Excel file to the server
#2. Load or keep the Excel file into the memory
#3. Query the excel file and convert into insert queries and execute
them via sql server
or
write a DTS package and use it via asp.net

Where can I find more information,
- Which is the best approach and what are adv. and dis-adv.
- How to set the properties of DTS package via asp.net

Any other related links are a good help.

Regards,

Sreedhar Vankayala

--

Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: RK | last post by:
Hi, In my application, I need to copy data from an Excel file into a SQL table. The article related to this can be found at http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306572 ...
3
by: davidw | last post by:
Hi, I read some articles about handle Excel in C#, they all need import Excel library. That means you need install Excel on that machine. I am wonderring SQL 2000 handle Excel, you can import...
1
by: Richard Holliingsworth | last post by:
Hello: Thanks for your quick response. I'm trying to import a new Excel file into an A2K table and it's truncating the data. One of the Excel columns is a text field that can be up to 2000...
6
by: Paul | last post by:
I was wondering if anyone has had an issue where using vba code to read an excel file and import the data into an access table some records are not imported from the excel file. It seems looking at...
9
by: hari krishna | last post by:
hi, I want to send the data from dataset information to Excel through ASP.Net. there will be no XL installed on web server. web server is win 2000 server machine. I am using visual basic code in...
3
by: Schultz | last post by:
I would like to know if it is possible to import data from MS Excel 2000 to a dataset using asp.net. The excel file would need to be uploaded to the server from a web page first, before the loaded...
4
by: alvinstraight38 | last post by:
Hey guys, I am trying to import data from an Excel spreadsheet into my SQL database. I am running SQL 2005. I following Microsoft's instructions for creating a linked server, and it appeared...
0
by: InnoSol | last post by:
Hi All, I am not familiar with MS SQL Server. I have one MS Excel file with datas such as date, name, Address such that. My client given one software to type those datas. The typed datas are...
16
by: giandeo | last post by:
Hello everybody I am trying to import an excel file for days into MS SQL Server 2000, unfortunately, I cannot see a ray of hope till now. I have surfed the WEB for hours, but again no...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.