import

[Steven Waters]

Bruce Easton wrote,

For that type of data, I usually use the tab-delimited export from Excel and
then on *nix, using vi remove any Ctrl-M's and quote marks with two ed
commands:

:g/^M/s/^M//g     (Ctrl-V,Ctrl-M to get the ^M) and
:g/\"/s/\"//g

Thanks, that is good advice.

I figured out a workaround for the csv problem
that I am having. Which is, some of my data has commas and
double quotes randomly in it. When I import csv, the data gets 
moved around. Jeff suggested to use a "~" This is not in any of
my data. So I found a work around. Go to;
Control Panel in Windows -> Regional and Language options -> Regional
options tab
Customize button-> List Separator. Change the "," to "~". Run the save as
csv
in excel and all of the separators are now "~". I imported to my 
file and it works great. Don't forget to change it back.
Also,
Is the DBCOPY part of Filepro or an add-on?

Thanks for all of the support