April 2, 2008 at 8:22 pm
Hi Guys
I am about to leave my present job as a SQL Developer. Now to make thing easier for the new person who takes up my role, I am designing store procedures for different queries I use to design database and create reports.
Now first step is to import an access table into SQl server 2005. I knoe it can be done through Import/export wizard .
But I want to create a stored proc which imports access file into my SQL database..
Can you please help me guys as you have always done in past???
Thanks:)
April 3, 2008 at 11:21 am
Check out "openrowset" in Books Online. That might accomplish what you need.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 3, 2008 at 11:29 am
Or - design a SSIS package which will accept a dynamic parameter. As described here:
http://www.mssqltips.com/tip.asp?tip=1395
I use this in conjunction with very simplistic VB form apps, so that you can use the standard "find a file" functionality, and simply pass that into the SSIS package to run.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply