load data from shared folder to servicenow instance

[DharamsingV]

I want to fetch the data every day from the shared folder and transform the data and update the records in a target table

I will get data in a excel format every day
i want to import the same data from the shared folder to the ServiceNow target table
Could anybody tell me how to achieve this requirement

Thanks

[rconstantino]

Very interested in this as well

[ronik reddy]

ServiceNow can’t pull files straight from a shared drive/folder on its own. So you usually do one of these:

• Move/copy the daily Excel file from the shared folder to somewhere ServiceNow can reach (for example, an FTP location, a web location, or by uploading the file).
• Or use a MID Server, which can “reach into” your internal network shared folder and help send the file into ServiceNow.
  Once ServiceNow can access the file, you can set up a scheduled import so it runs automatically every day.The normal ServiceNow way to load Excel data is:
• Create a Data Source (this tells ServiceNow where the Excel file is and what format it is).
• Load the data into an Import Set table first (think of this as a “staging area”).
• Use a Transform Map to match the Import Set fields to your target table fields, and do any data cleanup/changes during the load.

[rconstantino]

@ronik reddy - what would be the process to use a MID Server?