Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
Microsoft Access conversion |
Fri, Jun 26 2009 7:25 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |