January 22, 2003 at 8:54 am
I'm looking to build a tool that will allow data to be inserted via excel spreadsheets rather than through web interfaces that we currently have in place.
Well, the excel spreadsheets will eventually be uploaded through a web interface but it would allow our client service teams to work offline and enter data much faster when they are on line.
I have a couple of questions about this.
1.) Is it better to use DTS or stored procedures that use opendatasource/openrowset?
My initial thoughts are as follows:
I don't know how to use DTS. I've used it to insert excel files, but it seems like a black box. From what I understand, the insert would require the excel files to have predetermined names, and I don't seem to have much control over the flow of what happens.
I feel that I'm leaning towards completing this project using opendatasource/openrowset commands. Once the excel files are inserted into temp tables, I can massage the data into any other tables that I can think of.
2.) If approaching this problem with opendatasource/openrowset, what would be the benefit of using one over the other? How scalable are these commands ? Can they be used somehow in conjunction with a Bulk Insert statement?
So many directions to go on this one, any and all thoughts are appreciated.
Thanks,
-J
January 27, 2003 at 12:00 pm
This was removed by the editor as SPAM
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply