Is it possible to take a column from Excel xp/2000 and import it into an Access xp/2000 as a row. The headers (fields) reside in excel as a column and there are too many to put as excel column heads so we want to take the row of 5,000 labels and put them into access as the first row of a new table. Is there a simple way to do this or can someone point me to macro code? thank a lot.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing Excel column as Access Row 1
- Thread starter pe
- Start date
-
1
- #2
Hi PE:
Why not transpose the spreadsheet. Excel 97 will allow you to change row and coloumn heading.
Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.
1 Select the cells that you want to switch.
2 Click Copy .
3 Select the upper-left cell of the paste area.
The paste area must be outside the copy area.
4 On the Edit menu, click Paste Special.
Show me
5 Select the Transpose check box.
This was copied out of the Help section of Excel 97
Rich
Why not transpose the spreadsheet. Excel 97 will allow you to change row and coloumn heading.
Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.
1 Select the cells that you want to switch.
2 Click Copy .
3 Select the upper-left cell of the paste area.
The paste area must be outside the copy area.
4 On the Edit menu, click Paste Special.
Show me
5 Select the Transpose check box.
This was copied out of the Help section of Excel 97
Rich
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question