excel / import

GCC Consulting gcc at optonline.net
Wed Mar 16 04:41:03 PST 2005


 

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of Steven Waters
> Sent: Tuesday, March 15, 2005 3:49 PM
> To: Filepro List
> Subject: excel / import
> 
> Greetings,
> SCO FP5.0.14
> 
> I need to import an database from excel.
> When I save in .csv I don't get the needed open field 
> delimiter and close delimiter.
> my file looks like this;
> data1,data2,data3,
> 
> does anyone know how to get the data to look like this?
> 
> "data1","data2","data3"
> 
> I am having problems because some of the data has commas in it.
> TIA

 Steve

Easiest way to do this is save it as a dbf file and the use dbcopy to create a
filePro file.

Create a screen, check your data and then post it to your working file if the
one created isn't the file.

This method lets you "massage" and field data as necessary prior to posting.  

Granted, you can import this directly and massage it on the fly.  However, I
prefer the temporary file method as I can see how the data is coming in and make
any adjustments to the excel file that may be necessary.

Richard Kreiss
GCC Consulting 




More information about the Filepro-list mailing list