QV version problem: can't reload

[#1]

Hi,

I made a qvw in QV 10 SR1 without any problems but another user from my company opened the file in QV 9 SR6 and couldn't reload. I found out that if i use an asterix in the filename it doesn't want to reload but if i use the full path is does... Can i fix this?

LOAD
*
FROM
data\bfte*.xlsx
(ooxml, no labels, header is 1 lines, table is Blad1)

This doesn't work it gives an 'execution of script failed' error.

LOAD
*
FROM

(ooxml, no labels, header is 1 lines, table is Blad1)

This works... but that's just 1 file and there are more

pls help 🙂

[#2]

mmm weird i think it depends on the type of file cause i just tried to reload another file:

LOAD *
FROM

(biff, no labels, table is Blad1$);

This is a biff type of file and then i can use an * in my filename, QV9 SR6 isn't supporting asterikses for ooxml?

[#3]

mmm no ain't that either 😛 don't really know now what the problem is cause i can use an asteriks in other xlsx files. weird

[prieper]

Think that w/in the same directory you need to preceed with ".\".
Would also recommend to enclose the file-name with square brackets,

thus your script should read.

LOAD<pre>*
FROM
[.\data\bfte*.xlsx]
(ooxml, no labels, header is 1 lines, table is Blad1)

HTH
Peter

[#5]

yeah i knew, the problem was that some files were corrupt. In QV 9 SR6 it couldn't read them but in 10 SR1 it could. I copy pasted the data to another file and it worked 🙂 strange