Importing excel file with multiple sheets into SAS DI Studio

[wellylly]

Hi..
I wanted to import an excel file with multiple sheets into SAS DI Studio. Actually, it has 3 sheets but when i import it and sign a library with the excel file, there're 5 datasets created in the libary and some sheets have a duplicate with another name. Then i tried to use data validation to make sure the mapped columns, but when i registered the new table after validation, i run them all, then i got an error like this pict below. I have no idea to solve it.

I opened the log, then this is the error:

288        /* No validation to do - copy source table to target  */

289        data bnimap.TestMoney;

290           set TRS3.MoneyF$;

                            _

                            22

                            200

ERROR: File TRS3.MoneyF.DATA does not exist.

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,

             KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.  

ERROR 200-322: The symbol is not recognized and will be ignored.

.
.

Could anyone tell me the solution of this problem, please?? 

Thankyou..

[AngusLooney · Accepted solution]

Not going to help, but wherever you can, avoid Excel as a transport medioum for data, it rarely ends well.

One tip I remember was using the library member to tell you the names of the sheets, then use an access methos that lets you go straight to the individual sheets rather than the whole file in one go. Can't remember exactly how we did it, it was a good few years back.

[wellylly]

okay, thank you for the suggestion. I've tried using script to import the excel file and finally it works for each sheet. 
hehehe