Re: Transfer data from Excel to SQL Server

Billy Rogers wrote:
What's the best way to transfer data from Excel to SQL Server?

SQL 7 - SQL 2000 : DTS
SQL 2005: SSIS
Currently Using SQL Server 2000, Office 2000 and Office 2003

Use DTS. That's what it is there for.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Word 2001 for Mac: Toolbars Lead to Dead Ends
    ... Suzanne S. Barnhill ... please post all follow-ups to the newsgroup so ... >> Microsoft MVP ...
    (microsoft.public.word.docmanagement)
  • Re: Graphics with return address
    ... please post all follow-ups to the newsgroup so ... >>Suzanne S. Barnhill ... >>Microsoft MVP ...
    (microsoft.public.word.drawing.graphics)
  • Re: Format of addresses in personal letters
    ... please post all follow-ups to the newsgroup so ... it is not a standard MS format thats for sure. ... >> Microsoft MVP ... Several lines of typing in each address ...
    (microsoft.public.word.newusers)
  • Re: how do i paste a jpeg file onto microsoft word
    ... please post all follow-ups to the newsgroup so ... > "Suzanne S. Barnhill" wrote: ... >> Microsoft MVP ...
    (microsoft.public.word.docmanagement)
  • Re: on that note....
    ... please post all follow-ups to the newsgroup so ... >> Suzanne S. Barnhill ... >> Microsoft MVP ... >> Fairhope, Alabama USA ...
    (microsoft.public.word.docmanagement)