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?
Microsoft está realizando una encuesta en línea para comprender su opinión del sitio web de Technet. Si decide participar, se le presentará la encuesta en línea cuando abandone el sitio web de Technet.