Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 32. Sharing Excel Data with Othe... > Import Excel Information into Access

32.13. Import Excel Information into Access

You can import an Excel worksheet into Access to take advantage of Access features that are not available in Excel. For example, you might want to create Access reports or forms using data you originally set up in Excel. You can import the information you have already set up in Excel into a new or existing table in an Access database without affecting the Excel workbook. You can import a named range or an entire worksheet. If you want to import a workbook that contains multiple worksheets, you must import each worksheet separately using the steps in this section. The worksheet or range can contain headings in the first row.

You should use the technique described in this section when you anticipate importing the same Excel information into Access on a regular basis. This technique does not create a connection to the information stored in Excel. Changes to the information in Excel do not appear automatically in the Access table.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint