ASP data entry implementation

[Stephen Read]

Hello,
I need to write an ASP page that will allow a user to paste in
data from an Excel spreadsheet. The data will only be in one column. I'm
not a web programmer and would like some advice on the best way to do this.
I have a page working using a text area and some JavaScript to parse the
data entries using the split function. This seems to work ok but I wondered
if anyone could suggest a better way?

Many thanks

[Ray at]

Parse the data using server-side code? What do you not like the about the
way you're doing it? What are you looking to improve? What part are you
stuck on?

Ray at work

"Stephen Read" <St*********@NoSpam.com> wrote in message
news:c0**********@sparta.btinternet.com...

Hello,
I need to write an ASP page that will allow a user to paste in
data from an Excel spreadsheet. The data will only be in one column. I'm
not a web programmer and would like some advice on the best way to do this. I have a page working using a text area and some JavaScript to parse the
data entries using the split function. This seems to work ok but I wondered if anyone could suggest a better way?

Many thanks

[Stephen Read]

It's not that I don't like it. It was just that I'm inexperienced in asp
and wanted to see if it could be done in a more elegant way.

Thanks,

"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:ej**************@tk2msftngp13.phx.gbl...

Parse the data using server-side code? What do you not like the about the
way you're doing it? What are you looking to improve? What part are you
stuck on?

Ray at work

"Stephen Read" <St*********@NoSpam.com> wrote in message
news:c0**********@sparta.btinternet.com...

Hello,
I need to write an ASP page that will allow a user to paste
in
data from an Excel spreadsheet. The data will only be in one column.
I'm
not a web programmer and would like some advice on the best way to do

this.

I have a page working using a text area and some JavaScript to parse the
data entries using the split function. This seems to work ok but I

wondered

if anyone could suggest a better way?

Many thanks

[Ray at]

Well, it's hard to say. There are ways to do it with server-side code. Is
it more elegant? That's open to interpretation, I'm sure. I personally,
generally speaking, use server-side code whenever I can in favor of relying
on client-side code that runs in an environment which I cannot control.

Ray at work

"Stephen Read" <St*********@NoSpam.com> wrote in message
news:c0**********@sparta.btinternet.com...

It's not that I don't like it. It was just that I'm inexperienced in asp
and wanted to see if it could be done in a more elegant way.

Thanks,

"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:ej**************@tk2msftngp13.phx.gbl...

Parse the data using server-side code? What do you not like the about the way you're doing it? What are you looking to improve? What part are you stuck on?

Ray at work

"Stephen Read" <St*********@NoSpam.com> wrote in message
news:c0**********@sparta.btinternet.com...

Hello,
I need to write an ASP page that will allow a user to paste
in
data from an Excel spreadsheet. The data will only be in one column.
I'm
not a web programmer and would like some advice on the best way to do

this.

I have a page working using a text area and some JavaScript to parse the data entries using the split function. This seems to work ok but I

wondered

if anyone could suggest a better way?

Many thanks

[Bullschmidt]

You can connect to a csv file (which can be opened in Excel and which an
Excel file can be converted into) in good form just as you can to a
regular database.

And you can have two recordsets open at the same time.

So I'd suggest going through this recordset one row at a time and within
this loop add a new record to the "real" database's recordset.

And for help connecting to a text file using the Jet OLE DB provider:
http://www.able-consulting.com/MDAC/...roviders.htm#O
LEDBProviderForMicrosoftJetText

And based on the above link realize that the actual filename does NOT go
in the connection string - rather it goes in the SQL statement
(definitely a little tricky).

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!