| Ask Franco This is a free service where you can ask for help on any computer hardware or software related questions. Of course we may not always have the answer, but we will do our best. To send your question, click on Contact Us and type your question. | |
Here are some free stuff links that I have found very helpful
|
|
| Here is a work around to a common Microsoft Access error: Method ‘Columns’ of object ‘IImexGrid’ failed – This apparently has something to do with Access having trouble determining the size of the file you are importing or at least it seems that way. Here is a work around method – Open your Excel spread sheet and highlight the cells that have the data you want to import into Access. Next click on File, Print Area, Set Print Area or if you have the set print area icon on your toolbar, you can just click on it. Then save your changes and close your file. Open Access and try to import your spreadsheet again. This time you will be given 2 choices. Choose the bottom radio button “Show Named Ranges” which will let you import only the print area. Click Next and continue your import as normal. | |