Import from Excel..Field names in rows not columns

[Victoria @ WB]

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]

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]

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!