Thread: XLS files into flat files?
-
August 15th, 2002, 02:50 PM #1Member
- Join Date
- Jun 2002
- Location
- Manitoba, Canada
- Posts
- 77
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?
thanks
Ram09
-
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 #3Not Really a Member
- Join Date
- Oct 2001
- Posts
- 27,856
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.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)



LinkBack URL
About LinkBacks



Reply With Quote

The point was, since you missed it, is that if you are going to claim someone else did the same thing, provide proof to back up your statement. If, as you said, it was "one click away".
Oh, look! A NEW Obama scandal!!!