I found this code online to query Access and input the data into excel (2003), but it is much slower than it should be:
I am using an ExcelProvider with Microsoft.Jet.OLEDB.4.0 and am getting the Cannot Find Installable ISAM from the production machine.Windows Server 2003.
I\'m trying to change a password with a DDL statement like: CurrentProject.Connection.Execute \"ALTER USER barney PASSWORD 开发者_如何学C\"[]!@#$%^ oldpassword\"
I\'m needing to import an Excel spreadsheet into my program and have the following code: string connectionString = String.Format(@\"Provider=Microsoft.Jet.OLEDB.4.0开发者_开发技巧;Data Source={0};Ext