Posted by: STUPIDA May 5, 2008
SQL SERVER & Access Help/ IT
Login in to Rate this Post:     0       ?        

Hello to ALL IT people Out THERE !!!!!

 

MAy be in another couple of weeks , my IT group is gonna assign me a new project.

At presnt-- A small number of people uses Microsoft ACcess 2000 as their front end application to connect to SQL SERVER 2000. The Access is design with some tab buttons , which uses query to get data from sql server. They aslo use Import Export wizard to load data manually from excel to sql server 2000. and then move and archive those files. They say sometimes the file comes late and also format is not consistent.

Need FOR--- We are moving our database to SQL SERVER 2005. I think i can handle this part. ALso we want to get rid of Access as front end, becoz its slower. We are getting over the network to get data. May be write a small front end apllication in VB and connect to our SQL SERVER 2005 database. The store procedures and query used by access are also not optimized for performance.

I was thinking of replacing their manual load by SSIS packages, but according to them its hard becoz we don't know that what time  files will come. also sometimes format of excel file that we receive everyday varies..

I am not good at coding , but i can get help.

SO everyone out there plz help me to approach the problem, and also how can i sound techy and ready for this when i approach with this to my group on thursday,

Thanks

Last edited: 05-May-08 02:28 PM
Read Full Discussion Thread for this article