Thread: XLS files into flat files?
August 15th, 2002, 02:50 PM #1
- Join Date
- Jun 2002
- Manitoba, Canada
XLS files into flat files?
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?
August 15th, 2002, 03:06 PM #2
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.
Last edited by Imanage; August 15th, 2002 at 03:08 PM.
August 15th, 2002, 04:03 PM #3
- Join Date
- Oct 2001
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.Helicopters don't fly; they vibrate so much and make so much noise that the earth rejects them.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)