Importing An Excel CSV File
Walter Vaughan
wvaughan at steelerubber.com
Tue Nov 16 05:27:17 PST 2004
Art Moore wrote:
> I am using Windows XP Professional with filePro 5.0.5 and EXCEL 2003.
We're at 5.0.14 cowboy... you might wanna saddle up 'un getcha n upgrade
> 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.
Post the first couple lines of the original .cvs file here. I'm sure
it'll be just like this...
"80032535323234","134234","ASDF asdfA"
"01155512123445","231324","QRET asdfa"
Which filePro will be quite happy with.
You're letting Excel's presentation of the data drive your thinking.
The default view of numbers on your computer is set to display numbers
over a certain amount in scientific notation. Since you're opening a
.CVS file which contains NO formatting controls that's what you are
going to get.
So.
Open the file with NOTEPAD, and use that to assist you in the import of
data instead of Excel.
--
Walter
For those still reading...
If you have files with wierd control characters I have found that
edit.exe located in /windows/system32 will display them and allow for
replacing characters that do not display with Notepad or Wordpad.
More information about the Filepro-list
mailing list