exporting a multiple sheet worksheet to text

  • Thread starter Thread starter anne001
  • Start date Start date
A

anne001

I would like to export a multiple worksheet excel data to text.

CVS will not export multiple worksheets all at once and at
50 sheets or more * 50 files I don't want to do this work by hand.

I found
excel to SAS a super long macro I don't want to deal with
excel to R a package which does not load succesfully in R
excel to matlab, a function xlsread which does not work on a mac
excel to Ruby, a function with a 'require' calling for a PC package...

I can, I suppose figure out how to write a macro in excel
or install matlab on a pc
or figure out how to install and run ruby on a pc.

Is there something simpler I can do? Is there no way for excel to
export data to text, even if it is multiple sheet? Even if it requires
an intermediate step like folding all the sheets into one
(like merging layers in photoshop)?
 
You'd stand a better chance of getting an answer if you ask in a newsgroup
related to Excel.

This newsgroup is for questions about converting data to and from Access,
the database product that's part of Office Professional.
 
Ok, I had taken the word access in the generic sense.

By the way if somebody has such problems and is working with access,
, access seems to have an append fx which might help.
 
Back
Top