|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 11th, 2004, 01:33 PM
|
|||
|
|||
|
Import excel data through ASP page into MS SQL database
I'm working on a warranty database for my company. Each week we receive an excel file with all of the new warranty returns from GM, Ford and such. What I want to do is have a user go to a web page select the excel file and have it import into MS SQL.
Currently they e-mail the file to me and I import it with a DTS pacage I made. I realize the excel file needs to be formatted, X number of columns with specific names and data type, but how do I import it into SQL ???? Any ideas on how to start or a pointers in the right direction would be much appreciated. Thanks.
|
|
#2
August 11th, 2004, 02:24 PM
|
||||
|
||||
|
I've done something like that before, I've put up a file upload form and a subsequent asp page that launches the DTS, works very well.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
August 11th, 2004, 02:55 PM
|
|||
|
|||
|
Is there a chance that you can point me in the right direction, I can't see to find any info how to tie the DTS package with the excel file I'm trying to import.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Import excel data through ASP page into MS SQL database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
