Re: Can import from xls but what about csv???
From: Rick Sawtell (quickening_at_msn.com)
Date: 02/01/05
- Next message: pablosteward: "SQL Server Locks"
- Previous message: Jamie: "SnapshotIsolation Level and Com"
- In reply to: Eric Lovelace: "Can import from xls but what about csv???"
- Next in thread: Anthony Thomas: "Re: Can import from xls but what about csv???"
- Reply: Anthony Thomas: "Re: Can import from xls but what about csv???"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Feb 2005 08:59:49 -0600
"Eric Lovelace" <EricLovelace@discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
>
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
>
> Thanks in advance,
>
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
- Next message: pablosteward: "SQL Server Locks"
- Previous message: Jamie: "SnapshotIsolation Level and Com"
- In reply to: Eric Lovelace: "Can import from xls but what about csv???"
- Next in thread: Anthony Thomas: "Re: Can import from xls but what about csv???"
- Reply: Anthony Thomas: "Re: Can import from xls but what about csv???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
