DTS is one popular (and easy) way. You can set up a DTS package to import the spreadsheet, and then you can run that one time, repeatedly, or even on a scheduled basis as a job.
You can also use an Excel link in a Select statement. In fact, there is an on-going thread today about exactly that, so maybe you'd like to read it: thread183-267681
Because you can use a Select, that also means you can do an Insert Into, with the Select statement as the source.
Sorry, in my earlier post I missed the point that you were doing this from an application. I don't think my comment was any help at all, so please ignore.
I was thinking another Excel thread at the time, different from yours. My apologies.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.