SQL Table = Access DB Table = Excel Spreadsheet

[Phil Siedoff]

I'm in need of taking an Excel spreadsheet that has @ 5800 records of all different zip codes. Where many zip codes belong to one sale rep but also can have a different backup sales rep.

So with that spreadsheet, a SQL database table needs to be updated that is web page facing for customers, an excel spreadsheet that is intercompany facing that is used to update another excel spreadsheet. Finally, there is another spreadsheet that shows salesrep id's that gets updated with new zip codes from the us post office(whenever they add or subtract zipcodes) and sales reps who will belong to those zip codes.

How can I do all of this easily? or What is the easiest way to do this. DTS script? Batch file? Macro? not sure, and I'm not a DBA or programmer. Help...I'll need to get more info and files, but I believe that 4 or 5 columns are used in most.

Having trouble right now because the whole process is spagetti. We have SQL 2000, and Office 2003.

[ck9663]

Import your sheet (5,800 rows) -- let's call this transaction sheet, to SQL Server. Update the tables that needs to be updated then create macro on your other sheets to automatically or manually refresh their content. You may build a view, function or stored for each excel sheet that needs your data so you can hide columns depending on the requirement.

Good Luck!!!


~~ CK

[Phil Siedoff]

I'll give it a go, and followup. thanks-