Excel Blind Panic! Please help!!!!!

  wishtobwireless 17:40 PM 06 May 13
Locked

I have attempted to import an Excel spreadsheet 2300 lines into Access. It didnt import and my excel spreadsheet is now blank apart from the titled columns! I cannot explain how important this spread sheet is and realise how stupid i have been to not keep a good back up! Please please can someone help me to get back the spreadsheet or is all lost? Thank you for your help

(in my panic I thought I had posted this about half an hour ago, but cannot find it in the feed, so apologies if it is posted twice)

  Fruit Bat /\0/\ 17:47 PM 06 May 13

HAve you tried to reopen the spread sheet by ostarting another Excel?

  compumac 17:48 PM 06 May 13

If you only imported the spreadsheet into Access, the source spreadsheet is still in its original place, is it not?

  wishtobwireless 17:58 PM 06 May 13

Afraid not Fruitbat and compumac. I have re opened to original spreadsheet and it seems to have Access headings and all data wiped! When I go into Access nothing has updated or imported. Could it be lost in transit somewhere! Clutching at straws!!!

  lotvic 18:39 PM 06 May 13

can you open a version of spread sheet from the autosave copies. there should be one you can choose from before you did the import

  rdave13 18:41 PM 06 May 13

Have you looked in the temp folder? Shot in the dark. Windows Explorer, C drive, users, (your name), AppData, Local, then the Temp folder.

  Woolwell 18:55 PM 06 May 13

I have done this several times and have never come across your snag. If you have the access headings then it would seem that it exported to the file instead of importing and has overwritten the Excel data. I'm sorry but without a backup copy I don't know how you can recover the data.

  Secret-Squirrel 18:56 PM 06 May 13

The Windows "Previous Versions" feature may help get your data back. Here's where you'll find instructions for Windows 7 although it's also present in Windows 8 and Vista.

  compumac 19:03 PM 06 May 13

How did you import the spreadsheet and what versions of Excel and Access are you using?

  wishtobwireless 19:32 PM 06 May 13

Compumac I am using Access and excel 2007 Secret Squirel I am using Vista Woolwell thanks as I am fearing! Lotvic how do I get to auto save Just trying temp files now!

Back in a mo...

  Secret-Squirrel 19:42 PM 06 May 13

"Secret Squirel I am using Vista"

OK - here's another link for you. However I've just noticed that Previous Versions is only available in the Business, Enterprise, and Ultimate editions of Vista so you may not have that feature.

Advertisement

This thread is now locked and can not be replied to.

Sony Xperia Z5 vs Xperia Z5 Premium vs Xperia Z5 Compact: What's the difference between Sony's new ?…

1995-2015: How technology has changed the world in 20 years

This 3D food printer prints chocolate, cookie dough or pizza

iPhone 6S preview: What to expect from Apple's next iPhone