Import til Access 2000 fra Paradox 5.0

http://support.microsoft.com/kb/180105

Når jeg prøver at importere en tabel fra Accces kommer meddelelsen "Den eksterne tabel forekommer ikke i det forventede format!"

Jeg har den nyeste Jetupdate installeret.

have you looked at this link?
http://support.microsoft.com/kb/230126

another idea may be to export the data from Paradox and then import into Access

Fik installeret den Paradox 5.0 for Windows - kører fint i XP. Det ser ud til at den desværre kun kan eksportere tabeller.

Må se om jeg kan finde et værktøj, der kan konvertere forespørgsler og rapporter og måske datamodellen til Access.

As far as I know, you will need to convert your queries and report etc. by hand, but but may be able to find some other tool for doing this for you.

Så fik jeg konverteret forespørgsler i hånden, så mangler jeg rapporterne og der er rigtig mange :o( håber jeg kan finde et værktøj, der kan konvertere fra Paradox.

hows it going vanni?

http://support.microsoft.com/kb/180105(NOTE: If you install the latest Microsoft Jet 4.O service pack, you do not need the BDE to have write access to Paradox and dBASE files. The latest service pack resolves this limitation. For information about how to obtain Microsoft Jet 4.O Service Pack 5, see the following article in the Microsoft Knowledge Base:

(resolves nothing for me) jeg kunne ikke importere p.g.a. af forkert format, men måtte installere BDE for at kunne importere tabellerne.)
Alle rapporterne har jeg måtte lave i hånden. Forespørgslerne kunne jeg lure i Paradox og lave dem i hånden også.

Så jeg er færdig for denne omgang.

I undertsand the NOTE: To sya that IF you install SP5 then you can write to Paradox. This means that if you LINK the tables then you can make UPDATES in the Paradox database. It doesnt mean that you can import into Access WITHOUT have the BDE. So I think it is (was) necessary to install the BDE as you found out :o)

But we are still only talking about data (tables) NOT forms/reports.

Hi vanni, whats the status on this question?

Hi Terry,

Terry wrote: "But we are still only talking about data (tables) NOT forms/reports." No - the question was "Kan man importere tabeller, forespørgsler og rapporter fra Paradox til Access?" (not forms)

Jeg måtte lave alt "by hand" bortset fra tabeller, som jeg kunne have eksporteret/importeret via regneark.

The link I gave doesnt say that you can import queries and reports, only data (tables).
24/10-2004 18:54:14

Tabeller kan eksporteres/importeres via regneark og er ikke noget problem overhovedet vedr. Paradox 5.0 og Access!

god weekend vanni!

God weekend terry!