Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Microsoft Access conversion
Fri, Jun 26 2009 7:25 AMPermanent Link

adam
Sorry if this is somewhere on the newsgroups already, I can't see it anywhere obvious.

I have a customer with a simple self-built MS Access application which just doesn't work.

In total about 100,000 records are present in 4 tables.

I want to move the data to Elevate / DBISAM.

What's the best way to do this?
Fri, Jun 26 2009 10:26 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

adam


I'd probably go for export from Access to csv and import into ElevateDB or DBISAM

Roy Lambert [Team Elevate]
Fri, Jun 26 2009 12:00 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< Sorry if this is somewhere on the newsgroups already, I can't see it
anywhere obvious.

I have a customer with a simple self-built MS Access application which just
doesn't work.

In total about 100,000 records are present in 4 tables.

I want to move the data to Elevate / DBISAM.

What's the best way to do this? >>

You can use the BDE Database Transfer Utility to transfer the data directly
from Access to DBISAM.  Just make sure that you have the BDE installed, and
using the BDE Administrator, make sure that the AUTO ODBC option is enabled
(Configuration/System/INIT/AUTO ODBC=TRUE).

Then, you can just set up an ODBC DSN for the Access database using the ODBC
Administrator, and this DSN will show up automatically in the BDE
Administrator Utility.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jun 29 2009 12:59 PMPermanent Link

adam

>>You can use the BDE Database Transfer Utility to transfer the data directly
>>from Access to DBISAM.  Just make sure that you have the BDE installed, and
>>using the BDE Administrator, make sure that the AUTO ODBC option is enabled
>>(Configuration/System/INIT/AUTO ODBC=TRUE).

Sorry Tim, I haven't had BDE installed since about 1999 ... when I discovered DBISAM I
converted all my DBs over & dropped the BDE totally.

I remember though that it is only a couple of DLLs or similar?? I'm not even sure where I
would get those!

If I go with the CSV route suggested by ROY will I get data-types preserved? (i.e. dates,
floats, integers, booleans)

Adam
Mon, Jun 29 2009 1:12 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< Sorry Tim, I haven't had BDE installed since about 1999 ... when I
discovered DBISAM I converted all my DBs over & dropped the BDE totally.

I remember though that it is only a couple of DLLs or similar?? I'm not
even sure where I would get those! >>

You should be able to install the BDE by using any Delphi install since
Delphi 5.  Just un-select any of the main installation options except for
the BDE.

<< If I go with the CSV route suggested by ROY will I get data-types
preserved? (i.e. dates, floats, integers, booleans) >>

Sure, but you need to make sure that you get the table structures exactly
correct and that the export format from Access is replicated properly with
the DBISAM import (date/time/number formatting), or you will have import
issues.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image