import

[GCC Consulting]

-----Original Message-----
From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of Jeff Harrison
Sent: Tuesday, January 10, 2006 11:24 AM
To: 'Filepro List'
Subject: RE: import

--- GCC Consulting <gccconsulting at comcast.net> wrote:

> CONVERT TO DBF, AND USE DBCOPY.
> 
> THIS WILL AVOID THIS PROBLEM
> 
> Richard Kreiss
> GCC Consulting
>   

Yes, also creating an alien file will avoid the problem, also a tab
delimited file...  Oh, and probably about 7,013 other ways. :-)

Jeff Harrison
jeffaharrison at yahoo.com

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


		
Just thought he might want a solution witch was fast, did not involve a lot
of coding.

Since he is using Excel and has a number of formats to use in exporting the
data, this method might be the easy and get the job done. 

So, tell me what is wrong with using the available other tools that come
with filePro?  He is having a problem. Even if the import is successful, he
is going to have to insure that the data coming in is in the correct format.
Dates and zip codes can get messed up.  Date can come down in MS Julian date
format and zip codes can loose a leading 0. 

Doing a dbcopy gives on a chance to view the data before it is posted into a
working file.  One can then apply any necessary programming to insure that
the posted data is the correct format as to size and edit.

The nice thing about fp is that there are many available tools to that can
be used to accomplish a task

Richard Kreiss
GCC Consulting