XLS files into flat files?

**Ram09** · August 15th, 2002, 02:50 PM

Is there a way to get an excel file into a text file, one that could be read to a database? I was thinking of making a c++ program that would essentially take the excel file read it in and output a text file into a format that would be read in the database.

what happens with formula's if there is a way?

thanks

Ram09

**Imanage** · August 15th, 2002, 03:06 PM

You should be able to save the excel spreadsheet as a .CSV file (comma delimited format) field#1,field#2,field#3....etc

Do a file save as and select csv as the format. You should be able to read or import that back into a database.

I don't know what happens with formulas, but save the range that has the values populated.

**vass0922** · August 15th, 2002, 04:03 PM

I believe the values would be saved,and not the formulas that generated them. Besides that is better seeing as the database wouldn't understand that they are indeed formulas. The DB would probably treat them as a string and try to insert them as such. Your best bet would be to import all of the values and then do the coding necessary to make sure the values are correct.