Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-28 : 09:26:46
|
| Jon writes "I have a site where the administrator will need to update the main database once quarterly with information given in .xls workbook format. As it is an update and an amendment to the existing Database we have, the data needs to be checked against the existing for duplicates, and once this has been done, saved as the new-and-improved Database. I have tried DTS's but the client will be using the import procedure, so I have to keep it as simple as possible...any ideas on how I can acheive this???" |
|
|
|
|
|
Importing from .xls Workbooks