Office File Recovery

How to Convert a Linked Table into a Local Table in Your Access

We’ve said it before, but it’s worth repeating - linked tables can be really useful in your databases for a number of reasons. But one big drawback of linked tables is performance – running queries against them, especially if they aren’t Microsoft Access tables (i.e. if they’re Excel, CSV, or DBF files). They can be painfully s l o w to work with. There are a few ways you can work around that – we’ll work with one way here, and that’s to convert a linked table into a local...

Read more »

3 Effective Ways to Extract Cell Texts Only from Your Word Table

In this article, we would like to show you 3 methods to extract only the cell texts while coping from a Word table. Every time in the intention to copy texts from a Word table, it’s easily to select the entire cell. Thus, when we paste cell texts somewhere else, the cell borders are very much possibly go there too. Without much to say, cell borders are not favored in such case. Therefore, it’s necessary to eliminate them. Then the first thought that could strike to our mind may be to...

Read more »

How to Control Data Capture with a VBA Form in Excel

User capture into a spreadsheet is difficult to police; the entry point could be anywhere, and even locking of some cells provides no focus on the part of the user. A User Form with validation can provide an orderly channel for data capture into a spreadsheet. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”. Objective To produce the following form, which writes...

Read more »