excel column of data export format
Posted on 2014-09-03
Is there any possible to way to achieve the following.
I have an excel spreadsheet with a single column of data (in column A), the values are text/numerical, e.g. E45678, F45679. I need a way to export all the values to a text file into the following format:
('first cell of data', 'second cell of data', third cell of data')
ready for importing into a where clause on an external RDBMS. Is this possible? I know there is concatenate but with upwards of several hundred entries it would take an age to write such a formula, I need something more automated.