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

Chapter 6. Exhanging Data Annoyances > IMPORT AND EXPORT ANNOYANCES

IMPORT AND EXPORT ANNOYANCES

MOVE DATA BACK AND FORTH FROM EXCEL TO ACCESS

The Annoyance:

I've tried copying data from an Excel worksheet and pasting it into an Access database table, but the paste operation created errors. Is there an easy way to transfer data from Excel to Access? And vice versa, from Access to Excel?

The Fix:

There are several ways to handle this. One of these options is to simply use the Get External Data feature in Access. This method will import your Excel data and either put it into a new Access table or append it to an existing table. Here's how.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint