Importing

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

Guest

I am trying to import an Excel spreadsheet that has 10 tabs. Can someone tell
me how I can import the information into a table in access that will allow me
to see the other tabs within the workbook?
 
I'm not quite sure what you're asking. If you use the File|Get External
Data menu command you can select which worksheet to import into your
table. But there's no way an Access table can have multiple "tabs".
 
Here is the problem I have one excel spreadsheet that has 10 tabs or
worksheets within the spreadsheet 1 is for the region the other 9 are the
branches that fall under that region. . When I try to import the information
it only give me the choice to import 1 of the 9 tabs instead of all of them
at once. Would I have to create seperate table for each branch and them link
them once I have them imported in Access? Or is there an easier way?
 
You'll need to work out what data structure (tables and fields and
relationships) in Access best fits your data and the use you want to
make of it; then create that structure and import the data into the
table(s).

If the 9 "branch" worksheets all have the same structure and the only
difference between them is the branch they refer to, then it's best to
use just one Access table, with an additional field to specify the
branch.

To do that:

1) create the table with the additional Branch field.
2) Use File|Get External Data|Link to link to the first"branch"
worksheet
3) Use an append query to move the data to your main table. In the
query, use a calculated field like this:
Branch: "Name of branch"
to generate the value for the Branch field.

If the "regional" worksheet is just totals of data from all the
branches, it's probably not necessary to import it. Instead, you'd use
queries to aggregate the branch data as and when required.

It may be worth reading up on database design and normalisation. See
e.g.
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101
 
Back
Top