Date:         Mon, 5 Jun 2006 11:18:29 -0600
Reply-To:     Alan Churchill <SASL001@SAVIAN.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <SASL001@SAVIAN.NET>
Subject:      Re: Importing Data From MSAccess
In-Reply-To:  <200606051657.k55EBabN022761@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

One small suggestion. If possible, export to a tab-delimited format. If
using delimited files, tab should be a default specification without text
qualifiers. It will save you headaches later down the road.

Alan

Alan Churchill
Savian "Bridging SAS and Microsoft Technologies"
www.savian.net


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Arthur
Tabachneck
Sent: Monday, June 05, 2006 10:58 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Importing Data From MSAccess

Ankur,

In my version of Access (2003) after you select export you can identify the
file type (one of the types includes such types as txt, csv and a couple of
others).

If you select that type, you get to indicate that you want a delimited file
and, if you click on advanced, you can specify the desired delimiter
(,) and the text qualifier (").

Art
-------
On Mon, 5 Jun 2006 12:28:44 -0400, Ankur Shanker
<ankur.shanker@EVALUESERVE.COM> wrote:

>Hi all,
>
>There's a problem while importing data from MSAccess into SAS. My
>access dataset has close to 700,000 records. The procedure that I am trying
is:
>Exporting the access dataset as a delimited text file or a CSV file and
>then importing the files into SAS. But the problem is that while
>exporting the dataset from the access menu, it doesn't show the option
>to save as a .CSV file and it prompts an error message for the text
>file. And as a result, I am also unable to import the data into SAS.
>
>I have Base SAS and SAS Stat licensed and installed on my computer.
>Please suggest a way out of this.
>
>Thanks in advance,
>
>Ankur Shanker