At the end of your csv file, are you including ,\n ?
If you are using mysql on windows and LOAD DATA IN FILE you need to
include unix line breaks at the end of each line, else the data will
be loaded wacky...so if each line looks like this:
"","value1","value2","value3","value4"
change it to thi
try this:
1. export the data from ms access to a file on
the windows box.
2. fire up ftp from the command line and set it
to ascii mode.
3. ftp the file from the windows box to the
linux box.
if the eol is the problem, the ftp protocol will
insure that the eol is correctly translated wh
-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 1:02 PM
To: Schroeder, Bradley (Contractor); 'Black, Kelly W [PCS]';
[EMAIL PROTECTED]
Subject: Re: Problem importing data from Access
Hi,
You must use a HEX editor to see this characters which are not printa
uot; <[EMAIL PROTECTED]>; "'Gelu
Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 9:41 PM
Subject: RE: Problem importing data from Access
> The text
[EMAIL PROTECTED]
- Original Message -
From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
-Original Message-
From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
Sent: Wednesday, November 06, 2002 12:34 PM
To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: RE: Problem importing data from Access
This is incorrect.
!google &
This is incorrect.
!google "new line character" linux windows
-Original Message-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 11:33 AM
To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: Re: Problem importing
PROTECTED]
- Original Message -
From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 20
r 06, 2002 10:54 AM
To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED]
Subject: Re: Problem importing data from Access
Hi,
Are you sure that .txt file is OK?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
Hi,
Are you sure that .txt file is OK?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Schroeder, Bradley (Contr
Reformat your import file.
or
Add two columns , import, and drop the two columns.
or
Import to a six column temporary file and do an
insert into select from.
tl wrote:
>Hello,
>
>#If I have a file "t.txt"
>
>
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
><<
>
11 matches
Mail list logo
