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)
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!!!
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.