ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Exporting cobol files to excel (https://www.excelbanter.com/excel-programming/363402-exporting-cobol-files-excel.html)

Herpenc

Exporting cobol files to excel
 
Is het possible to export information from COBOL to Excel 2000 or Outlook 2000?
Does excel support cobbol files?

Thanks in advance.


tony h[_132_]

Exporting cobol files to excel
 

There are various ways to do this depending on quite what you want to
do. A common answer is to use ODBC. If you haven't got OBDC drivers for
your Cobol database you will find plenty of suppliers on the net. they
often require a little bit of configuration to get working.

You then use the DAO add in to use SQl to extract data from your Cobol
database directly into Excel.

Or you can export a CSv file from Cobol and open the CSV directly in
Excel.

Hope this helps to get you thinking in the right direction.

Cheers


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=548918



All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com