ASP good enough for this one?

[iamsw00sh]

I have an excel file

My asp project knows how to upload it (on the server)

step 1. I need to get the excel data inside my SQL (might be upgraded to SQL 2000) server (maybe in some temporary table)

from where:

step 2. I would get the data with some stored procedure or something and make some inserts (updates) to my tables ...


step to is not a piece of cake, but i know how to do it

the question is:
step 1

How could I do it?
What can i use?

ASP stuff? or SQL stuff ...?

What do you think?

Thanks in advance

--
cucu bau

 

[Bastien]

how is this being done? is everything on a local internal network? or from anywhere on the internet?

Bastien

Cat, the other other white meat

 

[iamsw00sh]

it's gonna be on the internet

an other one:

would it be better if it would be xml instead of xls? and MS SQL 2000 ... ?

i mean i could talk to the client ...

--
cucu bau

 

[Tarwn]

I would think that step 1 is overcomplicated. Why put everything in the database twice?

I would suggest:

step 1) Build a simple page with a form that has a file input on it
step 2) using something like ASPUpload, upload the file to the server and save it ina temporary location
step 3) since it is CSV you can grab the data with an ADO recordset
step 4) loop through the ADO recordset from the CSV file, doing whateve you need to push the data to the database
step 5) profit

-T

 

[ignoreme]

I agree with Tarwin.

Based on the stated (loose) requirements, that is the easier thing to implement.




"I think there is a world market for maybe five computers."
--Thomas Watson, chairman of IBM, 1943