Windows 10: how to save a excel file as a database file.

can not remember when I save a excel sheet as a database file. Is it .dbf or some other ending?

:)

 

Saves log files ?

You can either read the files in Windows or my preferred method is.....

Download CCcleaner from here...........

CCleaner Professional | Try the world’s most trusted PC cleaner, free!

You can then run cleaner, you will see the log files listed, then if you right click you can save as a text file and then have a read. You may also get an "error reporting" log listed seperatly.

 

Recover access database

Did you try this yet? http://support.microsoft.com/kb/283849

Run the Compact and Repair utility. To do so, follow these steps:

• If the database is open, close it.
• On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
• In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.
• In the Compact Database Into dialog box, enter a new file name, and then click Save.
  
  If the compact and repair does not succeed, you will receive a message stating so. This means the damage is so severe that it cannot be corrected.

 

Excel file

Hi zhiyang....,

I'm assuming that since you're using Excel 2011, that you have a Mac. Have you tried saving the file in the default 2011 format of XLSX?

While I have tested and can open both XLS and XLSX files on my Windows Phone, they were both created in PC versions of Excel 2000 and Excel 2010.

As a test, would you:

• First, try saving the file as XLSX and see if you can access the newer file format on your phone.

Otherwise, try the following as a test:

• Open up a web browser
• Go to Windows Live and login.
• Select "SkyDrive" at the top of the brwoser window
• Select the Excel icon near the top where it says "Create"
• Add a few numbers and do an AutoSum. Maybe add some formatting.
• Close the workbook (File -> Close workbook)
• Next, your SkyDrive file listing will appear with the new file.
• Click the "i" circle to the far right of the new file.
• Now, select "Send a link"
• Enter your e-mail information and click "Send"
• On your phone, open the e-mail and click on the button that says "View document"
• You should be able to view the document.
• If yes, then there is apparently a compatibilty issue on the Mac using XLS and I would try my first suggestion of trying to save the file in a different format like the newer XLSX.

By the way, the procedure gets easier in Windows Phone Mango (coming soon - no official release dates yet except in Japan) as you can save to and access files directly from your SkyDrive. That would eliminate the e-mailing it to yourself steps ... a lot easier!

I hope this helps!

David