Iniciar sesión
 
InicioBibliotecaAprendizajeDescargaSoporteComunidadForos
Recursos para Profesionales de TI >
> 
> 
Global search and replace of connection string

Respondida Global search and replace of connection string

  • viernes, 06 de abril de 2012 11:27
     
     
    Inicie sesión para votar
    0

    I have a client with approximately 4-5000 Excel workbook files that all contain the old Jet connection string and these files do not run under Office 2010 without changing to the newer ACE connection string.  It is just too much to open each file and change the connection string.

    Is there a way to do a mass change - like global search and replace - the connection strings in the files?   I have a text editor that is able to do that but I fear it may mess up the file.

    Has anyone had this problem and found a suitable solution?

    Thanks

     

Todas las respuestas