D
Darrell
I have spreadsheet with four columns. Division, Unit, Office, Position
Each Division, has multiple units. Each Unit has multiple Offices, and each
Office has multiple Positions. The spreadsheet has data in all four columns
for each record. I want to import the sheet into Access tried spit it into
four tables representing the four columns, but keep the relationship to the
data from each column. I tried the import wizard, but it does not show the
subdatasheets as I expected. Can I manipulate the wizard in a way to
accomplish what I want. I am trying to eliminate the duplicated is each
column. All columns have duplicate data accept for the position column. I
have as this point inported y sheet into access, and added a primary key
field.
Darrell.
Each Division, has multiple units. Each Unit has multiple Offices, and each
Office has multiple Positions. The spreadsheet has data in all four columns
for each record. I want to import the sheet into Access tried spit it into
four tables representing the four columns, but keep the relationship to the
data from each column. I tried the import wizard, but it does not show the
subdatasheets as I expected. Can I manipulate the wizard in a way to
accomplish what I want. I am trying to eliminate the duplicated is each
column. All columns have duplicate data accept for the position column. I
have as this point inported y sheet into access, and added a primary key
field.
Darrell.