migrating old access database over to a new one

Hello,

I'm trying to figure out how to migrate all my access database
information over to a new database that has been created. The new one
is almost identical to the old database, except it uses a different
schema. Is there anyway to do this automatically or will I have to
start doing some serious copying and pasting.

Thanks,

Rick

re: migrating old access database over to a new one

personally, I'd import all the old parts I wanted to keep... File/Get
External Data/Import

or are you just trying to move _data_? In that case, you can link to
the database(s) containing the tables etc that you want and either
import them or write an append query to copy the data to your new
tables...

re: migrating old access database over to a new one

You can use Append queries and Update queries to move your data.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.


<RSummersJr@gmail.com> wrote in message
news:1131135352.281555.264820@o13g2000cwo.googlegr oups.com...[color=blue]
> Hello,
>
> I'm trying to figure out how to migrate all my access database
> information over to a new database that has been created. The new one
> is almost identical to the old database, except it uses a different
> schema. Is there anyway to do this automatically or will I have to
> start doing some serious copying and pasting.
>
> Thanks,
>
> Rick
>[/color]

re: migrating old access database over to a new one

"PC Datasheet" <nospam@nospam.spam> schreef in bericht news:T7Qaf.4899$m81.3570@newsread1.news.atl.earthl ink.net...
[color=blue]
> If you can't get the help you need in the newsgroup, I can help you for a
> very reasonable fee.
> Over 1000 Access users have come to me for help.
> Need a month calendar or 7 day calendar? Contact me.[/color]

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
************************************************** ******

Explanation and more on this answer to Steve:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R

re: migrating old access database over to a new one

My free tool to do this is at http://home.gci.net/~mike-noel/CompareEM.htm

RSummersJr@gmail.com wrote:[color=blue]
> Hello,
>
> I'm trying to figure out how to migrate all my access database
> information over to a new database that has been created. The new one
> is almost identical to the old database, except it uses a different
> schema. Is there anyway to do this automatically or will I have to
> start doing some serious copying and pasting.
>
> Thanks,
>
> Rick
>[/color]