Re: Problem importing data from Access

2002-11-06 Thread John Ragan
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

RE: Problem importing data from Access

2002-11-06 Thread Schroeder, Bradley (Contractor)
- 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

Re: Problem importing data from Access

2002-11-06 Thread Gelu Gogancea
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

Re: Problem importing data from Access

2002-11-06 Thread Gelu Gogancea
[EMAIL PROTECTED] - Original Message - From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]> To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>

RE: Problem importing data from Access

2002-11-06 Thread Schroeder, Bradley (Contractor)
-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 &

RE: Problem importing data from Access

2002-11-06 Thread Black, Kelly W [PCS]
[EMAIL PROTECTED] - Original Message - From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]> To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednes

Re: Problem importing data from Access

2002-11-06 Thread Gelu Gogancea
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

RE: Problem importing data from Access

2002-11-06 Thread Black, Kelly W [PCS]
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

Re: Problem importing data from Access

2002-11-06 Thread Gelu Gogancea
adley (Contractor)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access > When I import data from the text file I exported out of Access it works > correctly except that MySql seems to append and/or pr

Problem importing data from Access

2002-11-06 Thread Schroeder, Bradley (Contractor)
When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the myst