On Sat, Mar 30, 2002 at 05:41:45PM +0530, Raju Mathur wrote: > >>>>> "Shridhar" == Shridhar Daithankar <[EMAIL PROTECTED]> >writes: > > >> though.. Thanks Shridhar, will give this a try after returning > >> to Office at the end of this extended weekend :-). Will it > >> manage the cells with formulae in them ? > > Shridhar> That depends upon how xls exorts them. If it exports > Shridhar> them as value then it should be OK. IMO it shoudl do > Shridhar> that. > > Come to think of it, why should you export calculated values at > all? A database isn't supposed to have fields whose values can > be calculated from other fields, though some databases support > (virtual) calculated fields. >
In principle, I agree with you Raju, the problem is, if I do a CVS import, I have no knowledge of how the computed fields are going to appear. If they are blanks or filled with correct values, fine. If they are going to be filled with some junk it is another bother As Philip suggested, transfering html or text from a M$ box though tedious would give me a visual indicator of what I am getting. I'll give the ODBC approach a try ... lets see how things shape up till then it is "Holi"-days ! Cheers Bish -- : ####[ Linux One Stanza Tip (LOST) ]########################### Sub : Unix to DOS conversion (#1) LOST #219 If you have vim editor installed, the following script will do Unix (text file) to DOS conversion: #!/bin/sh # Save u2d, chmod +x u2d vim -c ":set ff=dos" -c ":wq" $1 # Usage: u2d filename.txt ####<[EMAIL PROTECTED]>##################################### : _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
