Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Access and Excel (https://www.askmehelpdesk.com/showthread.php?t=5306)

  • Jun 12, 2003, 12:57 PM
    dotrain4u
    Access and Excel
    Is it possible to import simple information from a spreadsheet in Excel into a pre-existing Access table? If so, how?
  • Jun 17, 2003, 05:41 AM
    ScottGem
    Access and Excel
    Yes its very easy. In the Database tab, you select New, Import. Follow the prompts, one of them will ask if you want to append to an existing table.

    You might want to link to the sheet first and then use an Append query to make sure the fields match up right.


  • All times are GMT -7. The time now is 09:20 PM.