second frequency when importing from excel

[lomfy]

Hello! I'm trying to import secondwise data from an xlsx-file. However, my command doesn't work (it did for monthly data with "@freq m" instead of "@freq s").

import(type=excelxml) "00_intraday" range="Aufzeichnung!A1:BB1000000" colhead=2 namepos=last @freq "s" 11/05/2013 10:04:09

Is @freq "s" wrong? I couldn't find the abbreviation for secondwise....

Thanks!

Wolfgang

[lomfy]

Sorry, I forgot: I'm using Eviews 7.2. The error report reads:

Invalid frequency specification: "s" 11/05/2013 10:04:09 in "IMPORT(TYPE=EXCELXML) "00_INTRADAY" RANGE="AUFZEICHNUNG!A1:BB10000 ...

[EViews Gareth]

Try "Sec" rather than "s"

[lomfy]

Hey Gareth, thanks for the quicky reply - actually I stumbled across "sec" soon after i posted & tried it out straightaway.
import(type=excelxml) "00_intraday" range="Aufzeichnung!A1:BB1000000" colhead=2 namepos=last @freq "Sec" 11/05/2013 10:04:09

However, it still gave me the error message:
Invalid frequency specification: "Sec" 11/05/2013 10:04:09 in "IMPORT(TYPE=EXCELXML) "00_INTRADAY" RANGE="AUFZEICHNUNG!A1:BB100 ...

Any ideas why? Also, I must correct - I'm using 7.1, not 7.2....

[lomfy]

Ok, I got it - should have left out the " " here...sorry for the hassle ;-)