topic Re: ERROR: File _IMEX_. Warning when importing Access database in SAS Procedures

ERROR: File _IMEX_. Warning when importing Access database

cc1986 — Thu, 13 Feb 2020 17:03:07 GMT

Hi,

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! 🙂

Re: ERROR: File _IMEX_. Warning when importing Access database

Reeza — Thu, 13 Feb 2020 17:13:28 GMT

Is the table name over 32 characters? What's the actual table name and error?

Re: ERROR: File _IMEX_. Warning when importing Access database

cc1986 — Thu, 13 Feb 2020 17:40:20 GMT

Hi Reeza,

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?

Thanks!

Re: ERROR: File _IMEX_. Warning when importing Access database

Tom — Thu, 13 Feb 2020 17:55:38 GMT

Does the table name include strange characters? Something other than standard letters, digits and underscores? No accented characters, just A to Z. Does it start with a letter or an underscore? In other words is it a valid SAS name.

Re: ERROR: File _IMEX_. Warning when importing Access database

Reeza — Thu, 13 Feb 2020 18:13:37 GMT

Spaces in the table name?