By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,220 Members | 1,512 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,220 IT Pros & Developers. It's quick & easy.

migrating old access database over to a new one

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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...

Nov 13 '05 #2

P: n/a
You can use Append queries and Update queries to move your data.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@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.
<RS********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
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

Nov 13 '05 #3

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:T7*****************@newsread1.news.atl.earthl ink.net...
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.


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
Nov 13 '05 #4

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

RS********@gmail.com wrote:
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

Nov 17 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.