Importing from Excel

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

Is it possible to import a spreadsheet from Excel where the rows contain the
field names rather than the columns? I'm creating an Excel spreadsheet but
there are over 50 items to import and would like them to go down the
spreadsheet rather than across for ease of input for the user
TIA
Tony Williams
 
Hi Tony,

The standard import routine can't do this. Probably your choices are

1) Lay out the worksheet in the usual way, one row per record. Excel can
automatically create a data input form which may simplify the data entry
task.

2) Lay out the worksheet your way and use Excel's TRANSPOSE() array
function on another sheet to render the data with one row per record,
then import from that sheet.

3) Write custom code in VBA to import the non-standard layout.
 
John said:
The standard import routine can't do this. Probably your choices are

1) Lay out the worksheet in the usual way, one row per record. Excel can
automatically create a data input form which may simplify the data entry
task.

2) Lay out the worksheet your way and use Excel's TRANSPOSE() array
function on another sheet to render the data with one row per record,
then import from that sheet.

3) Write custom code in VBA to import the non-standard layout.
Click to expand...

Alternative to suggestion 1:
JWalk's Creating a database table from a summary table
http://j-walk.com/ss/excel/usertips/tip068.htm

Alternative to suggestion 2:
Copy the cells, switch to a new sheet then Edit, PasteSpecial, check
Transpose (checkbox at bottom right of the PasteSpecial dialog) then
OK.

Alternative to suggestion 3:
A really long UNION query (only joking <g>).

Jamie.

--
 
Back
Top