Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #760
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Download CSV file to SQL |
| Date | Mon, 31 Oct 2011 08:14:39 +0000 (UTC) |
| Organization | Erland Sommarskog |
| Lines | 17 |
| Message-ID | <Xns9F8F5E098E17AYazorman@127.0.0.1> (permalink) |
| References | <1ef23fba-b067-4f7f-8c4a-913073fcb898@q13g2000vbd.googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=us-ascii |
| Content-Transfer-Encoding | 7bit |
| Injection-Date | Mon, 31 Oct 2011 08:14:39 +0000 (UTC) |
| Injection-Info | mx04.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="16312"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+fhEVIWYBivu+TgKgedf8P" |
| User-Agent | Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) |
| Cancel-Lock | sha1:xRCcxGcfId/gmbfu5JJRdXOR+As= |
| Xref | x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:760 |
Show key headers only | 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
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