ms sql database daily.orders(basic customer info), items(product info and quanity), options (options of quantity). The problem is that 3 table has to get additional column when it is imported into sql. For example, when an order comes in its intranet application, it will keep track if it is in stock or out of stock checking the product table. those 2 databases ms sql and access or excel has identical columns but sql one has more in addition . This is my first time to work this kind of case and if somebody could give me a abstract step or suggestions to accomplish this.I'll be very happy;)
Thanks
kiss... use default values and/or dts to transfer the data to it's respective area.
if you wish to create an application to handle it, then just make your sql more precise to match your needs.
no need for kisses. It's unprofessional.
No comments:
Post a Comment