troubleshooting Question

Putting my Queries Together SQL Express 2005

Avatar of pippadewan
pippadewan asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
3 Comments1 Solution367 ViewsLast Modified:
Hi Experts...

I'm going to explain what I have to do manually to update my Access Database each day with the hope that one of you geniuses can walk me through creating a stored procedure which will allow me to just click something once and it runs the whole thing.. At the moment I am running each query individually... Somebody mentioned SSIS but I only have SQL Express and this is not supplied...

So I need to store the last months & last 5 days ccy tick prices in my Access Database.. I use Access as a front end to my SQL Express Database which holds all the records (to get around the 2 gig limit of Access)

I have linked the EURUSD5day and EURUSDMonth Tables in Express to Access via ODBC and happily it works fine on the Access side.. However everyday I need to open SQL Express Studio and click several queries to get these table updated...

So what I am asking is a way to automate the following queries....

1. Delete ImportTable (clear the records not actually delete the tables)
2. Delete EURUSD5day table
3. Delete EURUSDMonth table
4. Import .CSVfile to ImportTable
5. Append Import Table to EURUSD_all Table
6. Append EURUSD_all last 5 days data to EURUSD5day table
7. Append EURUSD_all last 30 days data to EURUSDMonth table

Thank you.... I have no idea if this is a really simple job or a difficult complicated one but I'm sure what I am asking is possible... In Access I use the built in Macro wizard to automate my access queries... but alas there is no equivalent in SQL Express...

Thanks for your time....

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros