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 |
|
batarsehs
Starting Member
9 Posts |
 Posted - 2005-06-21 : 14:58:00
|
| I have the database on MS SQL database that has a table called "phones", which is the one that needs to be updated with the new phone numbers that I receive from clients every week. Here is how it works:The different clients send me the data in different file formats, example, XML, CVS, Excel and Text. as well as different column "field" naming.I have an access database with a table for each client, where i import their files.Now instead of importing 15 files manually, i was looking into doing it at one click or step for all clients. I am looking to make this process as automated as possible. I want to create a marco or a VB that would insert all files at the same time, each to it's corresponding table. Since the naming differs every time the clients send their files, i wanted to run the VB based on a time line. for example, tue to Tuesday or wed to wed. Can you please direct me on how to go about this, please..... Thanks |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-06-28 : 09:46:19
|
| You may want to look at DTS. Details are in Books Online which is the help file that comes with SQL ServersteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
 |
|
|
|
|
|
|
|
import files data into access tables