I just copied a load of info from excel into access. Me not being very hot on access had the existing files highlighted when I pasted. Now the previous records are gone and I can't recover it! Is there a way of doing it? Please don't tell me i have to input over 1000 records again??
2006-12-22 01:18:47 · 7 answers · asked by emma42537 1 in Computers & Internet ➔ Software
I don't understand your question. How can the Excel file be "gone?" You deleted it? Did you "copy/paste" or did you Import??? You have to import. Access should have imported the data, not the formatting like highlights. Email me. I'm a database administrator (Access back end, Visual Basic front end"
rtr_thanos@yahoo.com
2006-12-22 01:22:11 · answer #1 · answered by Lamont M 3 · 0⤊ 1⤋
Bit late now, I know, but if you've still got the table open try CTRL+Z. If not, did it not ask you if you wanted to save changes?
Personally, I never work from an original db, I always make a copy & use that for just that sort of reason. Sorry to sound frivolous, I really am, but you live and learn!
Hopfully you can get it back - is there a copy on a server somewhere, perhaps?
It might come down to a lot of finger-work in the end, but that'll be a damn sight cheaper and quicker than getting a data recovery mob on the job
2006-12-22 03:16:37 · answer #2 · answered by champer 7 · 0⤊ 0⤋
Did you make a backup copy first?
If not, there are services that will try to recover lost data on a hard drive for a fee. There's no guarantee that they can do it, though, and the best thing to do is to shut that computer off NOW and not use it any more. I think you'll need to send the hard drive to them too. Do a search for "data recovery service" from another computer to find them.
2006-12-22 01:25:49 · answer #3 · answered by Ralfcoder 7 · 0⤊ 0⤋
Do you mean old data before copying from excel has been deleted..then so poor..it may be recovered...May be u can try
http://www.download3k.com/Press-Advanced-Database-Recovery-1.0-has-been-released.html
But if u concerned about excel data that you are importing, do not do copy and paste...
Right Clik in Table mode->Import
2006-12-22 01:23:48 · answer #4 · answered by Buzzy Buddy 3 · 0⤊ 0⤋
Well whats it worth for me to come and help you re input?
2006-12-22 01:27:12 · answer #5 · answered by Chianti Man 4 · 0⤊ 0⤋
OK
I wont tell you you that, and it will be true
... providing you have a backup.
if you dont' then better get busy with the old keyboard.
2006-12-22 01:35:14 · answer #6 · answered by Mark J 7 · 0⤊ 0⤋
they can be recovered but i dont know how or to what cost . sorry
2006-12-22 01:21:57 · answer #7 · answered by dean 3 · 0⤊ 1⤋