Hi--
I'm having problems importing a file that contains the following data
(close to 500 lines):
sample:
----------------
"Heritage";"5/2/00";"EOPS";12/30/1899 15:00:00;12/30/1899
17:00:00;12/30/1899 17:00:00;12/30/1899 15:00:00;"Claudette
Ellis";"Riverside";"cellis";"8123";100144;5/2/2000 0:00:00;"EOPS OPR Review
Staff Mtg";;"12";"12 Chairs and enough tables (set up) in a hollow square";
----------------
The delimiter is ";" and I'm using this:
COPY FROM <filename> INTO <mydbase> USING DELIMITER |;|
And it says bad format...Help!
Julio Cuz, Jr.
Riverside Community College
jcuz(at)rccd(dot)cc(dot)ca(dot)us