Kbase 21497: Problems Importing Data In Export Format Into Access?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Data has been exported from the Progress database using the EXPORT statement.
Loading data into Microsoft Access fails.
CAUSE:
One way that this can happen is if the file created on a UNIX based system, was ftp'd over to a Windows based system and the 'ASCII' transfer mode (BINARY is the default mode) was not used.
FIX:
Verify that the file has the proper end of line character sequence (CR/LF).