If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to transfer data to new Access d/b
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 |
#2
|
|||
|
|||
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 "Max" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I source a field in another data access page? | Stinger | General Discussion | 0 | January 22nd, 2005 12:31 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
transfer data from Excel to Access | L.J. | New Users | 3 | September 12th, 2004 08:15 AM |
Accessing a databse thru a webpage (newbie question) | Chang | General Discussion | 1 | August 23rd, 2004 09:10 AM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |