| Author |
Import from Excel..Field names in rows not columns
|
|
| Victoria @ WB 2005-09-21, 8:25 pm |
| Is it possible to import a spreadsheet from Excel where the field names are
in column A, rows 1-45 and the records are stored in columns B...Z? Each
column represents 1 record.
| |
| KARL DEWEY 2005-09-21, 8:25 pm |
| Insert a new worksheet in Excel. Copy the data by highlighting all of the
cells - not clicking the upper left corner.
Click in cell A1 of the new sheet. Click on menu EDIT - Paste Special and
near the bottom middle of the popup window clicl on Transpose. Click Ok.
Save.
Now import.
"Victoria @ WB" wrote:
> Is it possible to import a spreadsheet from Excel where the field names are
> in column A, rows 1-45 and the records are stored in columns B...Z? Each
> column represents 1 record.
| |
| Victoria @ WB 2005-09-21, 8:25 pm |
|
"KARL DEWEY" wrote:
> Insert a new worksheet in Excel. Copy the data by highlighting all of the
> cells - not clicking the upper left corner.
>
> Click in cell A1 of the new sheet. Click on menu EDIT - Paste Special and
> near the bottom middle of the popup window clicl on Transpose. Click Ok.
> Save.
>
> Now import.
Thanks. It worked great!
|
|
|
|