I have run into a problem when importing an Access database into SAS. The database has four tables, three of which imported with no problems, but the fourth gave me the following warning:
ERROR: File _IMEX_.tbl_name does not exist.
ERROR: Import unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.59 seconds
cpu time 0.06 seconds
(Note: I took the table's name is not "tbl_name")
I have tried copying the table name directly from Access and pasting the table name into SAS with no luck. The table itself only has 10 variables in it.
After some reading online, it's seeming like it might be an issue with my version of Access (64-bit Office 365) and its compatibility with my version of SAS 9.4 32-bit. I'm hoping this is not the issue, as I don't think I can control which version of Access or SAS I can use. If this is the case, why would all but one of the tables import? Why wouldn't all of them have issues importing?
Also, another coworker is having the same problems with an Access database she just created.
Any thoughts or suggestions on what the issue might be, would be much appreciated!
Thanks in advance for the help! 🙂
Thanks for your response! The table name is 22 characters, and in fact, one of the other tables that imported perfectly has a longer name. The error is exactly copied from the log minus the table name.
Do you have any thoughts?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.