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 - 2002-06-06 : 12:24:38
|
| Dan writes "I am trying to update a table called "customers" with information that our call center has in an Excel spread sheet. They receive updates to this spread sheet daily with employee changes (title, phone number, department, and other time consuming data entry). I would like to use there spread sheet to update my customer table for our internal helpdesk software and then maybe even import the customer table to our exchange GAL, so everything is up to date. Is DTS the best way to do this? I also need to duplicate a column based on the e-mail address column, since they don't have a user name field. How would I copy the E-mail address column and then remove the @mycompany.com and add mycompany\ (which would give me mycompany\username). I am new to sql, any help would be great!!!Dan" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-06 : 12:51:13
|
| Well, you WON'T like this option, but it's actually better. Create your SQL database as the standard for this list, and have them pull the data from it into an Excel sheet. If they need to make updates, you can make up a quick MS Access front end in about 10 minutes that they can use. BELIEVE ME, this is going to cause you much less aggravation than synchronizing with a Excel sheet as the standard.You can even get rid of the Excel sheet and put everything into Access, or even make up a web-based version and skip Access completely too. Excel is ALWAYS going to be a weak link, and YOU WILL have problems with the data at some point if you keep it. Web-based would really be optimal, because once it's set up there will be little maintenance and you can update it whenever you wish, and you don't have to distribute anything to anyone.If you want more information, take a look at some ASP sites, there are a number of ready-to-use code examples for stuff like this:www.4guysfromrolla.comwww.aspalliance.comwww.15seconds.comwww.asp101.comwww.learnasp.com |
 |
|
|
|
|
|
|
|
Updating a customer table with DTS