dbTalk Databases Forums  

Export xls data into sql server 2000 without using DTS utility

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Export xls data into sql server 2000 without using DTS utility in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dilip Singh Dodiya
 
Posts: n/a

Default Export xls data into sql server 2000 without using DTS utility - 09-22-2004 , 04:59 AM






I need to export .xsl file to sql server 2000 with out
using DTS utility.

Only through dts package or asp coding

Any help would be greatly appreciated.

Dilip Singh Dodiya



Reply With Quote
  #2  
Old   
Miguel Salles
 
Posts: n/a

Default RE: Export xls data into sql server 2000 without using DTS utility - 09-22-2004 , 08:09 AM






try using the wizard to create your process, in the end, choose to save the
package into SQL Server , you can even schedule it!
Otherwise, maybe you should try saving it as VB . bas file (VB module) and
then create a App. to run it!

Hope to have helped



"Dilip Singh Dodiya" wrote:

Quote:
I need to export .xsl file to sql server 2000 with out
using DTS utility.

Only through dts package or asp coding

Any help would be greatly appreciated.

Dilip Singh Dodiya




Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Export xls data into sql server 2000 without using DTS utility - 09-22-2004 , 04:15 PM



In article <396001c4a08a$dba57040$a501280a (AT) phx (DOT) gbl>, Dilip Singh Dodiya wrote:
Quote:
I need to export .xsl file to sql server 2000 with out
using DTS utility.

Only through dts package or asp coding

Any help would be greatly appreciated.

Dilip Singh Dodiya

OK

If I understand cirrectly then you will need to create the package in designer
or if you must the wizard. You then save it. You can then call the package
through your code

Execution
(http://www.sqldts.com/Default.aspx?104)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.