Exporting Pdox10 tables

[Ian Espie]

I am trying to export Pdox10 tables to MS Access, but Formatted Memo and
Graphics fields do not get exported. Any suggestions on how to get round
this problem? Thank you.

[Bertil Isberg]

Ian

Have you tried "insert into MSACCESS select from PARADOX" ?

--
Bertil Isberg
CTECH
FAQ newsgroup: corel.wpoffice.paradox-faq
Paradox Buglist: http://w1.826.comhem.se/~u82608896/

remove spamfilter (reversed) to reply

[Ian Espie]

Thanks Bertil for the reply. No I have not tried it. How do I do this ?

"Bertil Isberg" <bertil...@retlifmapsSCB.se> wrote in message
news:4189e3a7$1_3@cnews...

[Bertil Isberg]

You'll need an alias to the MS ACCESS database.

Create an INSERT QBE and try to run it. Otherwise you have to write the
SQL statement manually.

I'm not sure what happens with graphics and formatted memo though.

Often a tcursor is the best way to handle blobs.

[Ian Espie]

Thanks I will give it a try.

"Bertil Isberg" <bertil...@retlifmapsSCB.se> wrote in message

news:4189f543$1_2@cnews...

[Ian Espie]

I am having difficulty creating an alias to the Access database - its not so
intuitive.

"Bertil Isberg" <bertil...@retlifmapsSCB.se> wrote in message

news:4189f543$1_2@cnews...

[Bertil Isberg]

Ian

<<
I am having difficulty creating an alias to the Access database - its not so
intuitive.
>>

Which version of Access are you using? You may have to start with creating
an ODBC datasource for the Access database, and then create an alias. If you
have AutoODBC =TRUE in BDE Admin, you should get an alias defined
automatically. If you don't have AutoODBC=TRUE, you have to create an alias
in BDE Admin based on the Access ODCB driver and enter the ODBC DSN name in
the rgiht panel. Then rename the alias, it defaults to ODBC1.

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://w1.826.comhem.se/~u82608896/
FAQ newsgroup: corel.wpoffice.paradox-faq