Importing An Excel CSV File
Art Moore
cowboy at pcanswersinc.com
Mon Nov 15 19:14:56 PST 2004
I am using Windows XP Professional with filePro 5.0.5 and EXCEL 2003.
I have received an EXCEL file that I need to import to a filePro file. All of the fields in the filePro file have been defined as '*'.
When I save the EXCEL file as a .csv file so I can import it problems developed with what the EXCEL file lists as phone and FAX numbers. In the .csv file many of what should be phone numbers turn to exponential form. This only happens with phone numbers that are entered as just a string of numbers like 1234567890. When the entry is listed as 123-456-7890 there is no problem.
When the entry of 1234567890 is hi-lited an exclamation mark appears and says 'the number in this cell is formatted as text or has an apostrophe at the beginning'. The entry does have an apostrophe at the beginning.
Even if I change the format to a number left justified (or text) and save it, when I re-open the file it is back to the exponential form.
What am I doing or not doing to make these entries correct and stay that way when saved an opened as .csv file. Formatting as special/phone number does not do anything either.
When I open the file (saved a .csv) it does say EXCEL recognizes the file as a sylk file but cannot open it that way and so will open in another format if I want it to. I say okay.
Thanks in advance.
Art Moore
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20041115/98003957/attachment.html
More information about the Filepro-list
mailing list