|
Home > Archive > MS Access data conversion > July 2005 > Open Access IV to MS Access?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Open Access IV to MS Access?
|
|
| Grady W Smithey III 2005-05-10, 8:25 pm |
| The good folks at my office have been using Open Access IV as their
order-tracking software, and have finally decided that it's time to convert
to something more modern. Are there any tools that could make some form of
direct conversion from Open Access IV to MS Access, or am I going to have to
start building a database by hand?
Thanks for whatever help you can offer.
| |
| John Nurick 2005-05-11, 3:24 am |
| Hi Grady,
You should be able to export the data from Open Access to text or dbf
files and then import it to tables in the Access database. But all the
functionality of the database will have to be created from scratch using
Access's own tools. Given the different strengths and weaknesses of the
two tools, it's probably worth re-thinking the database design and user
interface in the process.
On Tue, 10 May 2005 15:31:41 -0500, "Grady W Smithey III"
<office@islagiatt.org? subject=Regarding%20
Your%20Post> wrote:
>The good folks at my office have been using Open Access IV as their
>order-tracking software, and have finally decided that it's time to convert
>to something more modern. Are there any tools that could make some form of
>direct conversion from Open Access IV to MS Access, or am I going to have to
>start building a database by hand?
>
>Thanks for whatever help you can offer.
>
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
| |
| Grady W Smithey III 2005-05-11, 1:24 pm |
| Thanks for the reply, John. I figured that I'd need to build a frontend, but
my big fear was that we'd have to enter all the data in the existing
database by hand into the new one.
We found an option to export from Open Access IV to dBase format, so now I
just have to start working on creating the tables and all. Thanks again for
the pointer.
"John Nurick" <j.mapSoN.nurick@dial.pipex.com> wrote in message
news:eq33815ik31evav
i3njhmfvipsah4j4299@
4ax.com...
> Hi Grady,
>
> You should be able to export the data from Open Access to text or dbf
> files and then import it to tables in the Access database. But all the
> functionality of the database will have to be created from scratch using
> Access's own tools. Given the different strengths and weaknesses of the
> two tools, it's probably worth re-thinking the database design and user
> interface in the process.
>
>
>
> On Tue, 10 May 2005 15:31:41 -0500, "Grady W Smithey III"
> <office@islagiatt.org? subject=Regarding%20
Your%20Post> wrote:
>
convert[color=darkre
d]
of[color=darkred]
to[color=darkred]
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
| |
|
|
"Grady W Smithey III" <office@islagiatt.org? subject=Regarding%20
Your%20Post>
wrote in message news:%23Fx2K8ZVFHA.3716@TK2MSFTNGP12.phx.gbl...
> The good folks at my office have been using Open Access IV as their
> order-tracking software, and have finally decided that it's time to
convert
> to something more modern. Are there any tools that could make some form of
> direct conversion from Open Access IV to MS Access, or am I going to have
to
> start building a database by hand?
>
> Thanks for whatever help you can offer.
>
>
|
|
|
|
|