Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Thursday, October 08, 2009 – Permalink –

Copy Paste

Excel tables

One 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.

[Edited entry from 9/16/2006]

See all Topics

Labels: Access, Excel

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link