Hi Jim,
J Shank wrote:
I use OpenOffice version 1.1.4 with Microsoft XP-Home on an HP 3200+ with 512 MB. I am trying to open a .csv file in Calc. According to the OpenOffice Help documentation, Calc should invoke the TextImport dialog; however, when I open the file, it appears in the Text Document module rather than Calc and the TextImport dialog never appears. Although I have Excel (97 SR2) I don't want to have to load it into Excel and then save in .xls format, then load it into OpenOffice. That seems to be a very long way around this problem. What then is the simplest way to load the data into OpenOffice Calc?
The easiest way if you have a text file that won't import into Calc is to go into Windows Explorer and locate the file and change its extension to .csv
Then Calc will most definitely open it.
Not exactly true.
I recently used SQLYOG to export a database table as .csv. The first line (field names) didn't include quotes around the names (Their bad). Nothing I tried would open the file in Calc until I put quotes around each entry in the first line. Then Calc became agreeable.
Doug
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
