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.