Hi Rita,

1. how to I transfer info from a column (in excel) to a row?

Copy -- Paste Special... Check the transpose box

2. for fields that have more than 1 entry per record, what is the best way
to enter that info into excel to easily export to access or will i have to
enter that info manually into access once it is set up.
3. finally, can excel be used as a db with multiple entries (as described
in
q#2 above) as part of the data

Check out my tutorial on using Excel as a database
http://www.edferrero.com/DataTutor01.aspx

Ed Ferrero