Refresh Ole Db Data Connection. VBA throws and application-defined or object-defined error and when I check the connection properties the last refreshed field is blank. With ActiveWorkbookConnectionsCJP_DeliveryRecap_DetailOLEDBConnection BackgroundQuery False CommandText SELECT SKU SKU_Desc Served Billed FROM mySQLdb Refresh End With This should help.
A new window will open. The settings in the connections are all greyed out but the connection still locks the other file up. Name your OLE DB connection.
In TSQL Query used the Hint Option 10000 Set the Commit Size for the OLE DB Destination to zero 0 Set Packet Size on OLE DB Connection Manager to.
In the Catalog pane right-click the Databases category and click New OLE DB Connection. Browse to the drive where your data is located. If your Excel workbook has a connection to a table or query in an OLE DB data source you can make sure it shows the most up to date information. Connection Array _.