Connect Ole Db Data To Your Workbook. For example you have a 32-bit application that uses the Microsoft OLE DB Provider for JetIf you migrate the application to run in the 64-bit mode the application cannot connect to the data source by using the Microsoft OLE DB Provider for Jet. This topic describes how to create a new OLE-DB data source to connect to a text CSV file for use with Endicia ProfessionalWith OLE-DB Endicia Professional can read a comma-separated text file with a column heading line.
XlApp New ExcelApplication xlWorkBook xlAppWorkbooksOpenDprotectxlsx ReadOnlyFalse Password123 Best Regards Julie. Click OK three times to exit all the dialog boxes and finish creating the new data source. The following C example tries to demonstrate how it is possible to create a new Excel workbook and worksheet with OLE DB.
When the data is transferred the connection is closed and the workbook that results is displayed in Excel.
XlApp New ExcelApplication xlWorkBook xlAppWorkbooksOpenDprotectxlsx ReadOnlyFalse Password123 Best Regards Julie. Configure the OLE DB connection manager in the following ways. Relate to Microsoft Access not Microsoft Excel. The following C example tries to demonstrate how it is possible to create a new Excel workbook and worksheet with OLE DB.