Please help

[newuser34]

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

 

[John W. Vinson]

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

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]

 

[FredFred]

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