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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-05-23 : 11:58:40
|
| Hi I have about 10 reports that are currently all manual, Data is manually extracted from at back end system, or automated and a file is placed on a network location, these files ranger from a access database to a excel file and .txt files.My job is to automate this whole process. 1. I hope I can get the back end systems to deliver the extract reports to a network location, this will not Be part of my project as its someone else part. 2. Assuming part one can be successfully implemented then I can start to automate my side.3. My question is, should I use ACCESS or SQL. Take into account the output of these reports will be in Excel, on a pivot table, that’s how the user will see them.Points to note. Currently the reports use lookups these can be replaced with actual tables in either SQL/AccessThere is a good deal of multiplication and Trimming of columns Date fields need to be automatedI've one excel file the needs to be cleaned up it needs the heading removed and the extra lines that are not needed. Also some columns get shifted to the next column they need to be corrected… (this is very messy) any ideas ??? 3.1 ACCESS, I know I can link a access table to the excel file, and once the file is on the network and it’s archived and then replaced with a new file each day then my table will be update. But for 10 different reports, this might not be the best way about it, as I like to have a single button on an access form to do this and it would go off and also refresh the report. 3.2 SQL, I've not managed to think about this much but by using a DTS I can link up to my external file on the network weather it be a access database, excel file or .txt files, so I can get the extract into my tables on SQL server there is how ever allot of data calculations to be done on the files and this is where I am thinking that SQL may win over Access. |
|
|
|
|
|
|
|
Access or SQL