Re: import dat from Excel to sql database 2005
Create a reference to the Excel automation library. Take a look at the members it offers, than extract the data from the relevant objects into your SQL data project. Finally, you can save the data.
My dad's called Mani - cool, huh?
__________________
[TRUTH] TcM is the best moderator ever! [/TRUTH]
"Valid XHTML is like sex - everybody claims to have the same goal, but everybody has their own tricks and results vary wildly."
Mr. Xav | Website | Forums | Blog
|