excel as database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
Click to expand...

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

Ed Ferrero
 
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
 
Back
Top