Hello all,
Well i am stuck for 2 days now on this conversion
database from Paradox->MSAccess->ASCII->import to MySQL problem.
I did:
- We have a paradox database (from Corel).
- Because i needed some query's i used Ms Access (yeah i know query's can also be done in mysql :)).
Well after i overwon a language table problem (paradox to msaccess i translated it to ascii instead of table language paradox, but never mind this) i had a 'good' MS Access 2000 database with also some
MEMO fields (TEXT/BLOB in MySQL) in it....
Ok so after the query's, i used the export function from MS access to get a ASCII file to import ....
When i tried to export MS Access 2000 database to a ASCII file, i selected all the option like | is the delimiter and so on.
After that the ASCII file was created... Well let's look in file with wordpad (with no wrap on) ....
Eh.. only a few records (10%) is in that file hmm.. where is the rest of my data ? damm...
Also a record is sometimes not 1 line, well maybe that's because in the memo field there are [enters],
but where is the rest of my data?
Can any give my a hint how to solve this ? I am really stuck on this problem ....
Possible:
- I have some memo fields (alias TEXT/BLOB in MySQL) in the MS Access database maybe that is a problem ?
- Export in MS Access 2000 don't work good ?
- Use MyOCDB (well i can't use that yet, because i am using a server from a i.s.p. and can only access in telnet, but i will soon have my own server) ?
- Select a other export in MS Access then ASCII .txt file ?
Hope anyone can help me.
Allready thanks.
Regards Startpoint.
Well i am stuck for 2 days now on this conversion
database from Paradox->MSAccess->ASCII->import to MySQL problem.
I did:
- We have a paradox database (from Corel).
- Because i needed some query's i used Ms Access (yeah i know query's can also be done in mysql :)).
Well after i overwon a language table problem (paradox to msaccess i translated it to ascii instead of table language paradox, but never mind this) i had a 'good' MS Access 2000 database with also some
MEMO fields (TEXT/BLOB in MySQL) in it....
Ok so after the query's, i used the export function from MS access to get a ASCII file to import ....
When i tried to export MS Access 2000 database to a ASCII file, i selected all the option like | is the delimiter and so on.
After that the ASCII file was created... Well let's look in file with wordpad (with no wrap on) ....
Eh.. only a few records (10%) is in that file hmm.. where is the rest of my data ? damm...
Also a record is sometimes not 1 line, well maybe that's because in the memo field there are [enters],
but where is the rest of my data?
Can any give my a hint how to solve this ? I am really stuck on this problem ....
Possible:
- I have some memo fields (alias TEXT/BLOB in MySQL) in the MS Access database maybe that is a problem ?
- Export in MS Access 2000 don't work good ?
- Use MyOCDB (well i can't use that yet, because i am using a server from a i.s.p. and can only access in telnet, but i will soon have my own server) ?
- Select a other export in MS Access then ASCII .txt file ?
Hope anyone can help me.
Allready thanks.
Regards Startpoint.