Using agrument in Sub as Table name

[Anonymous]

Hi All,

I am writing a sub to import data.

However, instead of pre defining the name of the table, i would like to make it a specified field.

i.e.:

sub Import(Dir,Table_Name)

     Table_Name:

          Load * ...

     From filelist( Dir& '/*.xlsx')

However, the table will always be named "Table_Name" no matter what string i used in the argument.

Please kindly advise.

Thanks!

Cheers,

GH

[sebastianlettner]

Hi,

use

$(Table_Name):

LOAD

     ...

Regards

Sebastian Lettner