Re: From excel file into MS SQL server

From: Simon Hayes (sql_at_hayes.ch)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 20:28:13 +0100

"no one" <noone@yahoo.com> wrote in message
news:41FF763D.6BFF199A@yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
>
> "Steve C. Orr [MVP, MCSD]" wrote:
>

<snip>

Have a look at DTS - it can load directly from Excel (or most other things)
to MSSQL, and you can change the source and destination connections at
runtime. This link discusses executing a package from ASP:

http://www.sqldts.com/default.aspx?207

Otherwise, you can parse the file and generate your own INSERT statements
(slow), or convert it to a flat text file and then use bcp.exe or BULK
INSERT to load the data.

Simon

Relevant Pages

  • DTS with asp
    ... I have 2 servers, so server web and sql server ... I not executing um package in page asp ...
    (microsoft.public.sqlserver.dts)
  • iissate "ASP.dll symbols not found. Unable to locate ASP page"
    ... post "ASP Requests Executing" ... Executing Page: ASP.dll symbols not found. ... Kernel Time: 0:0:0.0 ... User Time: 0:0:0.0 ...
    (microsoft.public.inetserver.iis)
  • Re: Access while running DTS package using stored procedure
    ... The permissions when executing xp_cmdshell can be different depending on who ... which the SQL Server service is running. ... > I wrote a DTS Package that can take the data from a .txt file residing ... > Declare @RunDTS as varchar ...
    (microsoft.public.sqlserver.dts)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... I have seen some scripts executing from a ... Gouvernement du Canada / Government of Canada ...
    (comp.os.linux.development.apps)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... takes root privileges to do so. ... I have seen some scripts executing from a ...
    (alt.os.linux.redhat)