I have an Access 2007 database application that contains an import specification to fill a table with data from an Excel spreadsheet (xls) that was generated by Cognos. Things have been well for two years.
We just upgraded Cognos to version 8 and although the filenames of the reports show an xls extension, I'm told that they are actually csv files. Instead of overwriting data in the table, the version 8 files cause the table to be deleted and the saved import spec no longer functions. The import must now be created manually each time we save a new copy of a Cognos report.
I tried creating a new import spec for a csv file but, because of cranky quotation marks in the data, this did not work well.
Any thoughts?
We just upgraded Cognos to version 8 and although the filenames of the reports show an xls extension, I'm told that they are actually csv files. Instead of overwriting data in the table, the version 8 files cause the table to be deleted and the saved import spec no longer functions. The import must now be created manually each time we save a new copy of a Cognos report.
I tried creating a new import spec for a csv file but, because of cranky quotation marks in the data, this did not work well.
Any thoughts?