Desktop productivity for business analysts and programmers

SAS EG Importing Access Tables

Reply
Frequent Contributor
Posts: 123

SAS EG Importing Access Tables

[ Edited ]

I'm using the import wizard in SAS EG to import tables from an Access database into SAS. The problem I'm having is I've successfully imported 12 tables from Access into SAS. When I try to import another, it's as if it overrides the first import - The import data icon will branch off into 2 output datasets instead of one even though it's an entirely different table in the Access db. So whenever I update something in those Access tables and try to import again, it only imports updates to the one I've most recently imported (the bottom one off the branch). See image below:

 

 

AccessImportError.PNG

 

 

Grand Advisor
Posts: 10,237

Re: SAS EG Importing Access Tables

 Have you tried importing the data into SAS Views instead of SAS data sets?

Frequent Contributor
Posts: 123

Re: SAS EG Importing Access Tables

I appreciate the response. What actually happened was kind of silly; the import icon was lying directly on top of the other one, so it looked like the two imported datasets were coming from the same import, when in reality once I dragged it down I saw that it was two separate imports. Weird that it would put it exactly on top of another one.

Ask a Question
Discussion stats
  • 2 replies
  • 232 views
  • 1 like
  • 2 in conversation