I have posted the same in many places without knowing as I am new to post forums,thinking there would be visitors based on the category. I would make a note...

Hi Gail, thank you it worked for me after removing the security. I ensured this with the network they sid their is a trusted connection between the servers, and asked...

I have verified the user permissions I have replicated exactly with user credentials that work with different application.

Have verified the connection string of an IIS server also ...

connectionString="data source=IP address,1433;Integrated...

I discussed it with the network admin but, they say as it is connected to the port 1433 there shouldn't be an issue as we have another application from the...

Is there any standard approach in the ways to administer the SQL Server databases. As I am new and have no experience in these I don't know where to start...

Is there any way to do this apart from scheduling it to check often.

YOUR RESPONSE IS HELPFUL.

Swetha K

The word automatic I mean here is "As the excel file is updated or inserted, the changes need to be reflected in the table with no time lag".

Swetha

I am given a task of automating the PDF data to a table ...... Looking out for possibilities/solution.

Thank you for the response.

Please let me know if you come across...