Re: Best practice to transfer data from Excel file to SQL Server 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: GD (NoSpam_g_du_at_comcast.net)
Date: 02/01/05 

Date: Mon, 31 Jan 2005 22:14:21 -0600

What I am working on is a web-based client-side application. The clients
don't have the permission to use the Import/Export Utility in SQL Server
directely. However, they are granted permision to perform database
transaction through web application.

Thanks for reply anyway.

GD

"WJ" <JohnWebbs@HotMail.Com> wrote in message
news:ecy26C$BFHA.3120@TK2MSFTNGP12.phx.gbl...
> You would want to use the "Import/Export Utility" shipped with the SQL
> Server CD. This is the best tool I see so far. I use this daily! On top of
> this, the tool also aloows you to schedule the job to run anytime you
wish.
>
> John
>
> "GD" <NoSpam_george_s_du@yahoo.com> wrote in message
> news:%23xIxgx%23BFHA.1264@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I am trying write a web application using ASP.Net to load an Excel file
> > from
> > client site and save all the data in the file to a table in SQL Server
> > 2000.
> >
> > My current assumption is: load Excel data to an ADO.Net dataset, or a
> > datareader, then pull the data out from them and insert the data to a
SQL
> > Sever table.
> >
> > I wonder if there is any better way to transfer the Excel data to SQL
> > Server.
> >
> > Thanks for any hints.
> >
> > GD
> >
> >
>
>

Relevant Pages

  • Re: Cannot insert or update columns from multiple tables (post #2) Need help please
    ... I cannot use a client-side cursor because the original tables has more ... Specifies that SQL Server will return to the DBLIB, ODBC, and OLE DB APIs ... Browse-mode metadata is additional metadata returned ... As you see it states that it will work for the client-side cursors only, ...
    (borland.public.delphi.database.ado)
  • Re: Formatting Numeric Value in Computed Column
    ... If the value is below 1, I don't want the preceding zero, e.g. .123. ... this is typically thing you should handle client-side. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Getting text message from DBCC commands
    ... configuration. ... it may be better to handle this client-side. ... But there is one more option to do it SQL Server: ... PRINT messages still are ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I use a <asp:button> to close a window
    ... > I know how to connect to SQL server and update tables but I don't know how ... > to close browser window after that. ... closing window is on client side. ... client-side JavaScript;). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)