Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
use
$(Table_Name):
LOAD
...
Regards
Sebastian Lettner