Importing from Excel

[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

 

[John Nurick]

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 Nurick]

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

Neat.