have an installed ODBC-driver called "MICROSOFT EXCEL DRIVER (*.XLS)"Ĭopy Code // this example creates the Excel file C:\DEMO.XLS, puts in a worksheet with two // columns (one text the other numeric) an appends three no-sense records.In order to get the code below going you have to To create and write to that Excel sheet you simply use SQL as shown in the code sample below. If it isn´t installed an exception gets thrown. If you just want to test if a certain driver is present (to show the supported extensions in the CFileOpenDlg for example) just try to CDatabase::OpenEx() it. This, of course, implies that the name of the ODBC-Driver is exactly known. Omiting the DSN tag in the connect string of CDatabase::OpenEx() gives us the opportunity to refer the ODBC-Driver directly using its name so we don´t have to have a DSN registered. This is not very useful because you´d have to install that DSN locally on every machine that should support your export function. ODBC does make this possible, but there´s one little drawback: Using ODBC the usual way there has to be a registered datasource (DSN) in the ODBC manager. So wouldn´t it be nice to be able to easily save that result as an Excel sheet?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |