Import from Excel..Field names in rows not columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
KARL DEWEY said:
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.
Click to expand...

Thanks. It worked great!
 
Back
Top