I'm exporting from a Pervasive database to a PostgreSQL from one ERP to another ERP system using an Access database. I'm linking to both databases using ODBC.
In the attached Access database I have a table from the Pervasive database that contains one row of data for the Fiscal Calendar/Periods.
I want to convert the table rows to 2 columns, the field name should be a column and the field data should be another column.
I also want to do the same for the query "fiscal periods in roman calendar"
Is this possible?