copy and paste from Excel into dap

[Guest]

Not able to copy and paste informtion from an existing Excel spreadsheet into
a DAP setup as a spreadsheet. Help!

 

[aaron.kempf]

do you mean the OWC spreadsheet control?
that is the easiest way to do this

-aaron

 

[Guest]

I don't know what the OWC spreadsheet control is. Please elaborate. What I
want is for a manager to easily select specific cells in Excel and paste that
information into the DAP (spreadsheet style). Does OWC do that?

 

[aaron.kempf]

yes, OWC will totally do that. it won't go directly into a database per
se-- but it will be a lot easier to work with; since it is all straight
xml then..


i used to work for a client that wanted this exact same thing-- i would
reccomend having them throw excel out the window.. and never look back.

DAPs rock!

-aaron

 

[Guest]

Still unclear exactly how to do this. Also, must continue using Excel,
required.

 

[Guest]

Is there anyone else who can step me through how to copy and paste info from
Excel into a DAP?

 

[aaron.kempf]

yes.. you can use the Office Web Components spreadsheet control

this will put the crap from excel into xml.. then you can parse it and
do whatever you want with it.
it's all just plain old XML once it gets into Office Web Components.

OWC is a control that is included in Office; these pages can be written
with a DAP.

if i were you though; i would concentrate on IMPORTING INTO A DATABASE
using either Access or DTS.

-aaron