excel / import

[Jeff Harrison]

--- Steven Waters <swaters at abiederman.com> wrote:

> 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

Steve, it appears that excel WILL put the quotes
around the data if the data contains a comma.  Try it
with some data that contains a comma and look at that
row/column to verify this.  If you use filepro's
import word command on this type of file it should
work OK.

Good Luck.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest way to generate code for filePro exports and
imports.





		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/