473,320 Members | 1,814 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,320 software developers and data experts.

Upload data

Hello

I'm trying to determine the best way to allow users to import data from an
Excel template to a sql server db via an asp.net page.

I'll have about 4 or 5 users that will need to create about 10,000 records
to populate a requirements table in sql server. They will gather this
information in an Excel spreadsheet/template and they apparently want to have
the ability to upload the records versus handing them off to some lazy, slow
developer like me.

I have used DTS in the past to import from Excel to sql server so my thought
is to create the asp.net page and 1. create a file upload that will allow
users to upload the Excel file to a specific folder on the web server (plenty
of examples of this around); and
2.once the upload is complete, execute a stored procedure to start the
DTSRun command line utility and import the records.

Is this the best way to do this? If anyone has a better approach or knows of
an example, I'd appreciate any ideas or feedback.

Thanks
Nov 19 '05 #1
1 1235
That sounds like a good idea, but you do not want the users to wait till the
process is complete. So you might either keep the job running in the
background while you store information about the files that are uploaded
into a table where the JOb can pickup and insert the records and do the
cleanup.

If on the other hand you are willing to do some research and see if this
fits into your requirement. There is something VSTO (Visual Studio Tools for
Office). Try to google and see if this will help.

Regards,

Trevor Benedict R
MCSD

"Mardy" <Ma***@discussions.microsoft.com> wrote in message
news:74**********************************@microsof t.com...
Hello

I'm trying to determine the best way to allow users to import data from an
Excel template to a sql server db via an asp.net page.

I'll have about 4 or 5 users that will need to create about 10,000 records
to populate a requirements table in sql server. They will gather this
information in an Excel spreadsheet/template and they apparently want to
have
the ability to upload the records versus handing them off to some lazy,
slow
developer like me.

I have used DTS in the past to import from Excel to sql server so my
thought
is to create the asp.net page and 1. create a file upload that will allow
users to upload the Excel file to a specific folder on the web server
(plenty
of examples of this around); and
2.once the upload is complete, execute a stored procedure to start the
DTSRun command line utility and import the records.

Is this the best way to do this? If anyone has a better approach or knows
of
an example, I'd appreciate any ideas or feedback.

Thanks

Nov 19 '05 #2

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

Similar topics

3
by: dave | last post by:
Hello there, I am at my wit's end ! I have used the following script succesfully to upload an image to my web space. But what I really want to be able to do is to update an existing record in a...
4
by: NohaKhalifa | last post by:
Dear All; I'm developing a web site and i need to make adminisration for this site it's a site for Real Estates . But I don't need the administration to be online .. I want them to fill data...
0
by: SEMIH DEMIR | last post by:
Sitelerden birinde verilen yabancı kaynakli bir scriptti duzenledim yanlız birseyin içinden bir turlu cıkamadım işin aslı ilk defa persistin upload componentini kullanacam yanlız suanki haliyle...
9
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web...
1
by: DavidA | last post by:
I have a very simple form and perl script that is to upload a jpg file. I am not familiar with the perl language but copied the code from a text book. It works fine with all browsers except IE....
7
by: pbd22 | last post by:
hi. i am having probs understanding how to grab a file being uploaded from a remote client. i am using hidden input fields for upload such as: <input id="my_file_element" type="file"...
9
by: 8anos | last post by:
Hello, I am new at the community and newbie at programming :) As you may know rapidshare provides a perl script for linux, to upload files at their servers. You can find the original scripts at...
9
by: Steve Poe | last post by:
I work for an animal hospital trying to use PHP to store an animal's dental x-rays to a file server. I can browse for the xray on the local desktop computer then click "Upload Image". This...
21
KevinADC
by: KevinADC | last post by:
Note: You may skip to the end of the article if all you want is the perl code. Introduction Uploading files from a local computer to a remote web server has many useful purposes, the most...
2
by: hotflash | last post by:
Hi All, I found the best pure ASP code to upload a file to either server and/or MS Access Database. It works fine for me however, there is one thing that I don't like and have tried to fix but...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.