Intel® Fortran Compiler
Build applications that can scale for the future with optimized code designed for Intel® Xeon® and compatible processors.
28602 Discussions

COM Server reads data from Access database

jdchambless
Beginner
270 Views
Does anyone know if/where a module exists that will allow my to read data from a Microsoft Access database? I am writing a COM server with the COM Server Wizard, and have found how to add and use the Excel functions with the Intel Fortran Module Wizard, but I am unable to figure out where the same would be for the Access library. Any ideas would be appreciated.
Thanks!
Jason C.
0 Kudos
3 Replies
Steven_L_Intel1
Employee
270 Views
Looks like "Microsoft Access 11.0 Object Library" to me (assuming Office 2003).
0 Kudos
jdchambless
Beginner
270 Views
Wow, I need a break apparently. Thanks for showing me the obvious way, Steve.
0 Kudos
jdchambless
Beginner
270 Views
Just a quick question if someone has a couple seconds:
How would you use "$Workbooks_GetItem($OBJECT, Index, RHS)" from the Excel 11 Library? I know that $Object can be obtained from a command like:

workbook = $Application_GetActiveWorkbook(excelapp,status)

where "workbook" becomes $OBJECT; and I know that "RHS" is just a return status, but I am unsure how or what the variant "Index" can be given a value. Any suggestions would be appreciated.
Thanks,
Jason C.
0 Kudos
Reply