TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
David Mayer
NA
5
0
Copy data from an Excel file into a SQL table
Mar 22 2007 12:32 PM
I am working on a web page which would do the following:
User clicks an "upload" button.
When button is clicked the following needs to happen:
1) Verify that the file exists
2) Copy the file to a designated location
3) Run a SQL 2000 DTS package to copy the excel file in to a SQL table
4) Delete the copy of the file at the designated location.
5) Validate that each step was properly executed.
6) Display either an error message or a successful message.
Please include any sample code if possible.
Reply
Answers (
1
)
Create a Folder and copy files to that folder from a web page
how can we connect to business logic layer from presentation layer ?