Date:         Fri, 19 Apr 2002 13:49:11 -0400
Reply-To:     dave@jadetek.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "S. David Riba" <dave@JADETEK.COM>
Subject:      Re: reading data from a text file through ODBC
Content-Type: text/plain; charset="iso-8859-1"

With all due respect (and VERY humbly, Sig), ODBC has a Text driver which
allows the definition of CSV, tab delimited, and custom delimited data
sources to ODBC.
Been around forever, not well known.
You can find it under the File DSN tab in the ODBC Data Source
Administrator.

Dave Riba

----------------------------------------------------------------------------
  S. David Riba                     INTERNET: dave@JADETEK.COM
  JADE Tech, Inc.                        http://www.jadetek.com
  P O Box 4517
  Clearwater, FL  33758               SAS Certified Professional - V6
  VOICE: (727) 726-6099             A SAS Alliance Partner
                  SSU 2001 Co-Chair   www.ssu2001.com
                  SAS.  It's not just an attitude


----- Original Message -----
From: "Sigurd Wilson Hermansen" <hermans1@WESTAT.COM>
Newsgroups: bit.listserv.sas-l
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Friday, April 19, 2002 1:31 PM
Subject: Re: reading data from a text file through ODBC


> Comma-delimited and text files do not contain the metatdata that ODBC
> needs to extract from a data source in order to read it into a SAS
> dataset. DBMSCOPY, for example, displays the contents of these files
> and helps a user supply the necessary metadata (including informats
> for dates, times, numbers, etc.). Sig
>
> "Daniele Monzali" <Daniele.Monzali@prometeia.it> wrote in message
news:<a9osnv$14q$1@panco.nettuno.it>...
> > hello all
> > does anyone know whether and how it is possibile to configure an ODBC
> > textpad driver in order to directly read .csv or .txt data files in SAS
?
> > thanks
> > daniele
>