How to load a number of excel files into one table?

[#1]

Hi,

I have 50 departments which user has a USERID. Each department has it's own excel file and maintains the file itself. These files are same table-structure and store in ftp-server, I set a FTP site which can allow department user login and update the excel files seperately

My requirement:

1 Now, I want QV load this files into ONE table. Can it go live? How can I write the script?

2 I create a section access with field of [USERID] [ACCESS] [DEPARTMENT]. I want user login and upload the file via QV document.

Could anybody help me on these issues at your most convenient?

[hector]

Hi, for your question no 1 you can use wildcards if the excel files are sharing the same structure, something like this

Load
field1,
...
fieldN
from excelfile*.xls (table ....)

so, qv will load all the files with names like excelfile1.xls, excelfile2.xls etc

For question no2, i have no answer, maybe with a macro could work

Rgds

[#3]

Hi,

For question 2 you have in the section acess a table that allow users to open the document and in the application section a table with departments, you just have to create a table that do a link between these two ones, and check the initial data reduction option.

[#4]

hi,i want to put ftp file via qv document sheet.:-)

[#5]

Hi Héctor Muñoz,

Your solution on Question1 is OK. It works well.

Can I use wildcards in table name(sheet name in one excel file)?