G Guest Nov 15, 2007 #1 I'm currently using excel to compile reports and would like to set it up in access. I would like to know how to set up the tables
I'm currently using excel to compile reports and would like to set it up in access. I would like to know how to set up the tables
J John W. Vinson Nov 15, 2007 #2 I'm currently using excel to compile reports and would like to set it up in access. I would like to know how to set up the tables Click to expand... In a way which reflects the logical structure of the data. Since you don't say what the reports cover, or what the data represents, how on Earth could anyone possibly answer? See the tutorials at: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials John W. Vinson [MVP]
I'm currently using excel to compile reports and would like to set it up in access. I would like to know how to set up the tables Click to expand... In a way which reflects the logical structure of the data. Since you don't say what the reports cover, or what the data represents, how on Earth could anyone possibly answer? See the tutorials at: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials John W. Vinson [MVP]
G Guest Nov 16, 2007 #3 You didn't give us much to go on. If you aren't using equations, then it could be as simple as using "get external dtat" in assess to import each spreadsheet into a corresponding table. Fred
You didn't give us much to go on. If you aren't using equations, then it could be as simple as using "get external dtat" in assess to import each spreadsheet into a corresponding table. Fred