ISITManager
IS-IT--Management
Hi,
I am fairly new to SQL Server 2000 and I am trying to import excel files with 'changing' names into a SQL database.
The name of the excel file changes every day (the format and column names remain the same), lets say ABC010109.xls on one day to ABC010209.xls the other day. I was wondering if I have to use VBScript to achieve my objective and if any of you can share it, or refer a link/site where I could look it up.
Thank you so much for your time..
Sincerely appreciate your help.
Thank you.
I am fairly new to SQL Server 2000 and I am trying to import excel files with 'changing' names into a SQL database.
The name of the excel file changes every day (the format and column names remain the same), lets say ABC010109.xls on one day to ABC010209.xls the other day. I was wondering if I have to use VBScript to achieve my objective and if any of you can share it, or refer a link/site where I could look it up.
Thank you so much for your time..
Sincerely appreciate your help.
Thank you.