Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

importing data sas access

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing data from SAS to Access

Importing data from SAS to Access

ResolvedVersion 2003

Jon has attended:
Access Introduction course

Importing data from SAS to Access

What is the best way to import a database from a third party application like SAS (Statistical Analysis System) for analysis in Access? SAS can export as delimited data, .csv and .txt files.

RE: Importing data from SAS to Access

Hi Jon

Thanks for your question

I suggest that exporting the data from SAS into a text file would be the best approach, as Access has a wizard to import data from text files.

Go to Tools-Import and in the resulting dialog box change the file type to Text File. Select the file and the wizard will guide you through the process

Regards

Stephen


Tue 10 Aug 2010: Automatically marked as resolved.

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.