|
|
Saturday, May 22, 2004
|
|
| |
Copy Paste.
Access
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.
See all Topics
[Unofficial Microsoft Office Stuff]
4:21:15 PM 
|
|
|
|
© Copyright
2004
Paul.
Last update:
6/14/2004; 9:04:03 PM.
This theme is based on the SoundWaves
(blue) Manila theme. |
|
| May 2004 |
| Sun |
Mon |
Tue |
Wed |
Thu |
Fri |
Sat |
| |
|
|
|
|
|
1 |
| 2 |
3 |
4 |
5 |
6 |
7 |
8 |
| 9 |
10 |
11 |
12 |
13 |
14 |
15 |
| 16 |
17 |
18 |
19 |
20 |
21 |
22 |
| 23 |
24 |
25 |
26 |
27 |
28 |
29 |
| 30 |
31 |
|
|
|
|
|
| Apr Jun |
|
