excel as database

[Rita]

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

 

[Ed Ferrero]

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

 

[Rita]

Thanks for that.
Looks like I complicated my life by having the info originally entered in
Word. I have multiple info in some cells and they need to be manipulated
before pasting into excel. I'll be installing access shortly, and will check
with the access group if i can go directly from word to access, unless you
can answer that.
Thanks again.
Rita