Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel as database
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel as database
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 "Ed Ferrero" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
import specific fields only from excel to database | Excel Discussion (Misc queries) | |||
Accessing oracle database through excel cell | Excel Discussion (Misc queries) | |||
Query Excel database from desktop | Excel Discussion (Misc queries) | |||
Set Database in Excel | Excel Discussion (Misc queries) |