Groups > comp.databases.ms-sqlserver > #760

Re: Download CSV file to SQL

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Download CSV file to SQL
Date	2011-10-31 08:14 +0000
Organization	Erland Sommarskog
Message-ID	<Xns9F8F5E098E17AYazorman@127.0.0.1> (permalink)
References	<1ef23fba-b067-4f7f-8c4a-913073fcb898@q13g2000vbd.googlegroups.com>

Show all headers | View raw

Spero (robspero@gmail.com) writes:
> A client provided me with a web site that I do not need any login or
> anything, I just visit the http sit and ot will open the dialogbox to
> save or open. Is ther anyway to save this file and import to a table
> in sql with CLR or directly through a query?
 
If this is a one-off, the simpliest for you is probably to use the Import 
Wizard in SQL Server Management Studio.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Download CSV file to SQL Spero <robspero@gmail.com> - 2011-10-30 20:42 -0700
  Re: Download CSV file to SQL Erland Sommarskog <esquel@sommarskog.se> - 2011-10-31 08:14 +0000

csiph-web