Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Sunday, June 19, 2016 – Permalink – Copy PasteExcel tablesOne way to create a new table in an Access database from information included in an Excel spreadsheet is to select the pertinent data on the spreadsheet, including the field names. Copy the selection (Edit>Copy, or CTRL+C) Switch back to Access . With Tables objects being shown in the database window, choose Edit>Paste, or use the CTRL+V shortcut. Access will ask if the first row contains the field names and then will paste the information as a new database table. See all Topics excel <Doug Klippert@ 3:20 AM
Comments:
Post a Comment
|