[mdb-dev] FW: mdbtools problem - more info about the problem

[Shahriar O. <sha...@po...>]

More info:
I did this command:
DROP TABLE dbo_SECURITY_M020A;
CREATE TABLE dbo_SECURITY_M020A
 (
        SECURITY_NUMBER                 Text (22),
        SECURITY_NAME                   Text (60),
        REPORT_NAME1                    Text (120),
        REPORT_NAME2                    Text (120),
        CUSIP                   Text (24),
        TICKER                  Text (24),
        CEDOL                   Text (24),
        ISIN                    Text (24),
        ISSUER_NUMBER                   Text (22),
        ISSUER_CODE                     Text (20),
        SECURITY_TYPE                   Text (12),
        INSTRUMENT                      Text (4),
        ACTIVE_STATUS                   Text (2),
        ISSUE_CURRENCY                  Text (6),
        INCOME_CURRENCY                 Text (6),
        INCOME_FREQUENC                 Unknown 0x00 (2),
                                Text (8),
                                Text (2),
                                Text (4),
                                Double (8),
                                Text (8),
                                Text (40),
                                Text (40),
                                Text (4),
                                Double (8),
                                Text (8),
                                Text (40),
                                Text (40),
                                Text (2),
                                Double (8),
                                Text (22),
                                Double (8),
                                Double (8),
                                Text (2),
                                Integer (2),
                                DateTime (Short) (8),
                                DateTime (Short) (8),
                                DateTime (Short) (8),
                                DateTime (Short) (8),
                                DateTime (Short) (8),
                                DateTime (Short) (8),
                                Text (4),
                                Integer (2),
...

It seems that mdbtools doesn't show column names for this table some how.

Thanks

-----Original Message-----
From: Shahriar Ofavezi [mailto:sha...@po...]
Sent: Thursday, April 20, 2006 3:33 PM
To: mdb...@li...
Subject: mdbtools problem


Hi,
I have a problem. I was working with mdbtools and ms access 97 on Linux OS
with no problem.(JET4)
I could load the data from access to text file and load it with Oracle
sqlloader into Oracle database.
Now I am getting the same tables and data in MS Access 2000 database. I make
a text file from my tables, all of them work, except one of the tables. It
shows bad characters in text file and some how I get null in some of the
columns. When I open it in access, I can see the data with no problem. When
I load data from MSAccess2000 (the same table) to Oracle with Visual Basic,
i don't get any problem. Just when I use mdb-export in Linux environment and
MS Access2000, the text file which it creates, has bad data.
Data is look like this:
           ,"                              ","
Y              ","          Y
","            ","            ","            ","            ","
","        NL","G CAD "," N"," ","   ","CA ",,"    "," ","  ",100.000000,"
","          N         ","                    ","  ",100.000000,"
 ","<94><8>|\Z2*"" ^^^\^V^P^NøòðêèÃ","ÃÃÃ
                                    û<94>~|fP:86&$^P^L

or another column:

:00:00","06/09/06 00:00:00","06/09/06
00:00:00","","""^^",0,"^Rþèø <88>^P<9,"06/09/06
00:00:00",0.000000,0,"F",100.000000,0.000000,0,0.000000,0.000000,0.000000,""
,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.0
00000,"Bÿÿç¿^?ûÿ",0.000000,0.000000,0.000000,"<9f>","·","^C","",0.000
0?",0.000000,"",0.000000,"",0,"","","",0.000000,0.000000,0.000000,0.000000,"
","","","","","","","",0.000000,"","",0.000000,"",0.000000,"","",0.000000,""
,"",0.000000,"",0.000000,"","",0.000000,"","","04/13/06 00:00:00","12/13/01
20:45:52","","","","","",0.000000,0.000000,0.000000,0.000000,0.000000,"",0.0
00000,0.000000,0,0,"",0,"",,"","",0.000000,0.000000,0.000000,"","","","","",
2

and another sample:

ô","ò",100.000000,"â<9a><96>nF>:80*",0.000000,1.000000,"$",0,"","","03/0
6/06:00:00","03/06/06 00:00:00","03/06/06
00:00:00","","""^^",0,"^Rþèø <88>^P<9,"03/06/06
00:00:00",0.000000,0,"F",100.000000,0.000000,0,0.000000,0.000000,0.000000,""
,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.0
00000,"Bÿÿç¿^?ûÿ",0.000000,0.000000,0.000000,"<9f>","·","^C","",0.000
0?",0.000000,"",0.000000,"",0,"","","",0.000000,0.000000,0.000000,0.000000,"
","","","","","","","",0.000000,"","",0.000000,"",0.000000,"","",0.000000,""
,"",0.000000,"",0.000000,"","",0.000000,"","","01/30/06 00:00:00","12/13/01
20:45:52","","","","","",0.000000,0.000000,0.000000,0.000000,0.000000,"",0.0
00000,0.000000,0,0,"",0,"",,"","",0.000000,0.000000,0.000000,"","","","","",
2
           ,"                              ","
N              ","          N
","            ","            ","            ","            ","
","        NL","E CAD "," N"," ","   ","CA ",,"    "," ","  ",100.000000,"
","                    ","                    ","  ",100.000000,"
 ","<94><8>|\Z2*"" ^^^\^V^P^NøòðêèÃ","ÃÃÃ
ô","ò",100.000000,"â<9a><96>nF>:û<94>~|fP:86&$^P^L,"$",0,"","","04/2
7/06


Thanks