Automatic Table Name when using * in reload script

[#1]

Hi:

I was trying to load some excel file with part of the name are the same with each other.

So I use the wildcard * like follow:

Table:

LOAD

     [Field Name]...

FROM

[File Path\FileName*.xls]

(biff, embedded labels, table is Sheet1$);

The first excel file load in OK with the name Table as assigned.

But he rest of the excel load in a table with the name 'Table-1'.

How can I make all excel files load in to the same table with the name 'Table' ?

Thank you very much.

PC

[anbu1984]

It should have created only one table

[jonathandienst]

Hi

For some reason there is a difference in the first loaded table's fields, and the fields in the subsequent tables. I suggest that you post your script, and if possible two of the excel files (just the first 5-10 lines) for further diagnosis. As the previous post said, they should have been auto-concatenated.

HTH

Jonathan

[#4]

Hi Jonathan:

I found that the my first file is slightly different from the rest of the files.

All the fields in the LOAD session are available for all the excel files but the first file is an old version which means the order of the fields is different and some of the new fields are not included.

Do you think that could be the reason?

It it is, how can I make them into one table?

Thank you very much for your time.

Paco