General information
Category:
Coding, syntax & commands
>>We have a large amount of code which captures a data set and then gives it to a user as a spreadsheet. We've been using COPY TO (filename) XLS and, for the most part,
>>this has worked well for us. We haven't run into too many issues with large data sets (these were broken down into multiple sheets and have a different routine if the dataset contains memo fields.
>>
>>I'm now running into situations where we are going to have a significant number of datasets with more records than COPY TO XLS can handle and I'm looking for advice on the easiest way to turn them into XLSX files.
>>
>>I have some ideas (do the first chunk as XLS. Convert it to XLSX. Do the extra chunks as XLS and then COPY/PASTE the records) but they feel clumsy and I'm sure there has to be a better way.
>>
>>All feedback appreciated.
>>
>>........... Rich
>
>I had a similar situation and solved it by first copying to a CSV file, then using Excel Automation to import the CSV file and saving as XLSX.
Thanks for the response.
I don't think CSV will work for us. Many of our data fields have embedded single quote and double quote characters.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only