How can I export table with array columns

[William Hicks]

I need to export data from tables in a Progress database that contain array columns so that it can be imported into MS SQL Server for analysis. The database in question doesn't have username/password so I can't use ODBC, as works for other databases.
I have generated scripts to create the tables in SQL Server from which include the array columns expanded out so an array of 100 would create 100 columns named col##1 to col##100.
However, when I export the data from Data Administration->Admin->Export Data->Text... the array columns are not included when choosing All fields form the radio button nor are they offered when choosing Selected.
How can I export the table data including the array columns?
Progress is v10.2. Dev environment is on Windows 10 Enterprise. Database is on Linux.

 

[Osborne]

Really surprised by this as it appears to by design:

Progress Customer Community

community.progress.com

The Data Administration Tool does not support the EXPORT or IMPORT of array fields.

Can you apply the suggested resolutions?

If you need to export multiple tables then this dynamic option may be useful:

Progress Customer Community

community.progress.com

 

[TomBascom]

The lack of a username & password for the database does not, by itself, prevent ODBC access.

But a simple 4gl program will also easily export the problem table:

output to value( "problemTable.csv" ).
for each problemTable no-lock:
  export delimiter "," problemTable.
end.
output close.

 

[William Hicks]

Thank you both. Admin->Dump Data and Definitions->Table Contents, as suggested by one of the articles., was what I needed.