i have a sample data and report in excel i need the same in access , where i can submit my data to get the report ??? , as i am a user and not have programming idea.
-
-
Hi kcy000. There really isn't enough useful information in your post for us to answer your question other than in generalities.
It is possible in Access to import Excel data into an Access table, or to create a linked table in Access which links to the data in Excel. All that this does is give you a means to access the data; there is no automated way to create a report from that data based on some other 'report' in Excel, although what you mean when you say 'report' is not at all clear from the very little information you have provided.
Generally speaking, whilst data in Excel can be input to Access it is rarely structured in such a way that Access can make direct use of it as a relational table. Excel is so free-form that its tables often contain multiple entities in the one table. Excel has no means of enforcing relationships or even the most basic of rules about what should be placed where in its 2D grid of cells, so the data in an Excel table rarely meets the kind of conditions for relational data which relational databases require.
Welcome to Bytes!
-Stewart
Comment