Edit Excel data in Access
Excel is very powerful, is not it? But sometimes you will find that if exce document contains so much data excel will become very slow, it is because for those who excel not need to deal with a large amount of data users and design. If you have a large amount of data to deal with, and the need of many other Excel function of the formula could not be completed, I suggest that you use a database, for example, Access. Access is a desktop database software, although it is not professional, but I think to some extent it meet your request, for example, to deal with those that excel handle more data. And the use of the database language SQL, you can also make some very simple to excel, the more complex tasks, for instance, that you want to excle in a series of all the figures are added another figure in this task in exce more complicated, but the use sql language, you can use a very simple order to complete this task.
Well, you first need to import data from Excel inside out, and this how do Which? Do not worry, you create a document Access, click menu “document”, and then click “access to external data”, and then inside the dialog box pops up to open the file type changes. xls, and then select you want to open the document excel it.
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Right now is imposible to edit excel data from access after I use the “access to external data” Before with access & excel version 2002 are possible this feature.