How to transfer data to new Access d/b

[Guest]

I am about to create my new database tables, based on what I've presented in
previous posts here. After I create the tables, is there an easy way to
transfer the data? I don't necessarily want to transfer all of the data
immediately, just about 50 or so records until I am assured that my new
set-up works. Just to clarify what I mean by "easy," the old-school me
first thought I have to literally type in all the records manually, one at a
time .... please tell me there's a better way.

I can justify my learning database design "on-the-job" because #1, I am
learning something new to add to my resume, and #2, it should eventually
benefit the employers, but I just feel that plain ol' typing is not worth my
time (not like it was 25 years ago, lol).

In peace, and thank you all again for the ongoing support,

Max

 

[Rick B]

I don't understand why you are making a new database if you have one that
does what you want.

The easiest way I could see is to simply copy your current fiel to a new
fiel All the data, tables, forms, queries, etc. will be there. Then go in
and delete anything you don't need.

Another ooption would be to create your new database. Add a "linked" table
to your old database. This linked table will have a picture of all the
records in your old database. You could then create an append query to grab
select records (you decide the criteria) and append them to your new empty
table. Once you have all the data you need, simply delete the linked
table(s).

You'd have to explain what you are trying to accomplish in a bit more detail
for a more specific answer.

Hope that helps,

Rick B