Old data to new databse

[RitchieJHicks]

Hi,

I have a database called "core data" which I have now expanded with some
extra fields in my updated application. Whilst I still use all the old fields
from the old database, I have many new fields in my new database. My old
database has been used up to today by my staff and I am now ready to bring
the new system online.

What is the best way to import my old database into the new database,
ensuring that exisiting fields are kept the same and that the new fields are
not effected?

Rgds,
Ritchie

 

[AndyB via AccessMonster.com]

Hi Ritchie,

I presume from the way you have described your problem, that you have
basically copied your old database file, cleaned out the data and added new
fields to the table(s).

If this is the case, you should simply be able to run an append query in the
old database to copy all existing data to the new database.

Provided you haven't modified the field types of any of the existing fields,
all old data should be copied accross & your new fields will be left void of
data.

If I've got the wrong end of the stick ,let me know.

Andy B

 

[RitchieJHicks]

Hi Andy,

Yes - I made a copy of my old db, cleared the records (but left the fields).
I now need to import the data from my current (soon to be old) db.

So yes, you have got me right. However, I am not sure how I would run an
append query in these circumstances. Can you provide a link to any decent
intructions or guides on this?

Regards,
Ritchie

 

[AndyB via AccessMonster.com]

Richie,

I need the answer to a question or two first:

Is all your data in a single table?
Do you use an 'Auto Number' field in the table? and if so, what for?

If you are using multiple tables, are any linked and how?

We have to be sure that any linked fields retain their links in the new
database.

Andy

Hi Andy,

Yes - I made a copy of my old db, cleared the records (but left the fields).
I now need to import the data from my current (soon to be old) db.

So yes, you have got me right. However, I am not sure how I would run an
append query in these circumstances. Can you provide a link to any decent
intructions or guides on this?

Regards,
Ritchie

Hi Ritchie,

[quoted text clipped - 27 lines]

 

[RitchieJHicks]

Hi Andy,

Yes, my data is in a single table.
Yes, I use autonumber. I generates a reference (starting at 0) and is the
primary key. So far I am at record 2845.

Yes, linked tables are used. However, they only link back to the main data
table and not to each other.

Hope this answers your questions. Sorry, I am not overley technical with
this just yet!

Regards,
Ritchie.
--
-----------------------

Richie,

I need the answer to a question or two first:

Is all your data in a single table?
Do you use an 'Auto Number' field in the table? and if so, what for?

If you are using multiple tables, are any linked and how?

We have to be sure that any linked fields retain their links in the new
database.

Andy

Hi Andy,

Yes - I made a copy of my old db, cleared the records (but left the fields).
I now need to import the data from my current (soon to be old) db.

So yes, you have got me right. However, I am not sure how I would run an
append query in these circumstances. Can you provide a link to any decent
intructions or guides on this?

Regards,
Ritchie

Hi Ritchie,

[quoted text clipped - 27 lines]

Rgds,
Ritchie

 

[AndyB via AccessMonster.com]

Hi Ritchie,

That makes life easy.

Make sure your new database is closed.

Open the old database

Create a new query and add your data table

Drag & Drop all fields into the query datasheet

As a default, this will be a 'Select Query. You need to change that to an
'Append Query using the query type drop-down on the menu bar.

As soon as you select 'Append Query, a dialog will appear where you can
select your data table and choose to append to another database.

Browse for your new database file, then click OK.

Running this query will copy all existing records to your new database.
(Leaving your new fields void of data of course).

I can't envisage any problems, but it's always worth backing up both database
files before you start.

Andy

Hi Andy,

Yes, my data is in a single table.
Yes, I use autonumber. I generates a reference (starting at 0) and is the
primary key. So far I am at record 2845.

Yes, linked tables are used. However, they only link back to the main data
table and not to each other.

Hope this answers your questions. Sorry, I am not overley technical with
this just yet!

Regards,
Ritchie.

Richie,

[quoted text clipped - 27 lines]

 

[RitchieJHicks]

Bingo. It worked. What a star!

Thanks for your help.

Best Regards,
Ritchie.

Hi Ritchie,

That makes life easy.

Make sure your new database is closed.

Open the old database

Create a new query and add your data table

Drag & Drop all fields into the query datasheet

As a default, this will be a 'Select Query. You need to change that to an
'Append Query using the query type drop-down on the menu bar.

As soon as you select 'Append Query, a dialog will appear where you can
select your data table and choose to append to another database.

Browse for your new database file, then click OK.

Running this query will copy all existing records to your new database.
(Leaving your new fields void of data of course).

I can't envisage any problems, but it's always worth backing up both database
files before you start.

Andy

Hi Andy,

Yes, my data is in a single table.
Yes, I use autonumber. I generates a reference (starting at 0) and is the
primary key. So far I am at record 2845.

Yes, linked tables are used. However, they only link back to the main data
table and not to each other.

Hope this answers your questions. Sorry, I am not overley technical with
this just yet!

Regards,
Ritchie.

Richie,

[quoted text clipped - 27 lines]

Rgds,
Ritchie

 

[AndyB via AccessMonster.com]

My Pleasure.

Have Fun

Andy

Bingo. It worked. What a star!

Thanks for your help.

Best Regards,
Ritchie.

Hi Ritchie,

[quoted text clipped - 43 lines]