View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
rita rita is offline
external usenet poster
 
Posts: 64
Default excel as database

I need to transfer info from word (table format in columns) to excel
ultimately to be used in access (once purchased/installed). In the meantime
3 questions.

1. how to I transfer info from a column (in excel) to a row?
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

Many TIA
Rita