Importing data from excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I was wondering do SQL Server 2005 has a built in tool to import data from
excel table to a sql table ?
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643
.

Relevant Pages

  • Re: Importing data from excel
    ... Ammar S. Mitoori ... IT Head QIMCO Co. ... SQL Server as the destination. ... linked server to the Excel workbook and then use T-SQL to pull the data. ...
    (microsoft.public.sqlserver.tools)
  • Re: sql command error
    ... Ammar S. Mitoori writes: ... you posted now, includes no SQL statement, and I can't see any ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: SSIS and unicode data types
    ... my varchar columns are at most 50 characters. ... destination column in the SQL database destination is only varcharor ... How do I get an Excel column of datatype ... It left SQL Server as a VARCHAR and went into Excel, ...
    (microsoft.public.sqlserver.dts)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Excel 2007 connection
    ... The Feature pack also contains the SQL Server Client ... You should install it. ... so I installed them both as I do for Excel 2003. ...
    (microsoft.public.sqlserver.olap)