Sep 14th, 2000, 10:33 AM
I'm about to create a tool where the client user provides data updates by uploading an Excel spreadsheet. The .xls file should be validated and if its OK the data are stored in our SQL7.0 database.
This is likely to happen say 2-3 times a day, and should not severely interfere with server performance otherwise heavily burdened by end users.
Now which is the best way to go considering performance cost and 'do-ability'?
Do I have to create an instance of an Excel application each time the task is executed?
Can ADO take care of everything (there seems to be a bug in ADO when reading numeric data from spreadsheets)?
Other suggestions?
DTS, XML or something else?
Thanx heaps to anyone who can save me from walking into a dead end.
/JT
[ADO 2.5, SQL 7.0, VB 6]
This is likely to happen say 2-3 times a day, and should not severely interfere with server performance otherwise heavily burdened by end users.
Now which is the best way to go considering performance cost and 'do-ability'?
Do I have to create an instance of an Excel application each time the task is executed?
Can ADO take care of everything (there seems to be a bug in ADO when reading numeric data from spreadsheets)?
Other suggestions?
DTS, XML or something else?
Thanx heaps to anyone who can save me from walking into a dead end.
/JT
[ADO 2.5, SQL 7.0, VB 6]