Page 1 of 1

How do you to change Exel DB to csv?

Posted: Mon May 07, 2012 6:13 pm
by jack54
Hi all,

I have been editing the RUS data base Lodilefty was kind enough to post. I have been adding bios and wanted to check my work by creating a new local$tring file (csv) from the exel DB, I am using Exel from MS office 2007. If I try to export the data base (it has 3 pages) I get an error saying .csv does not support multiply pages.

thanks, Jack

Posted: Mon May 07, 2012 7:17 pm
by lodilefty
jack54 wrote:Hi all,

I have been editing the RUS data base Lodilefty was kind enough to post. I have been adding bios and wanted to check my work by creating a new local$tring file (csv) from the exel DB, I am using Exel from MS office 2007. If I try to export the data base (it has 3 pages) I get an error saying .csv does not support multiply pages.


thanks, Jack


You must export each 'page' or 'tab' as a separate csv.

http://www.ageod.net/agewiki/Csv_splitter

Then you'll need to use the csv splitter.