mdbtools problem
"Shahriar Ofavezi" <[email protected]>
| Newsgroups | gmane.comp.db.mdb-tools.devel |
|---|---|
| Message-ID | <[email protected]> |
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
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642