Importing Excel Data with Drop down lists

[Raj]

I need to import excel spreadsheet to Access 2003. The excel file has
several columns with drop down list. When I import the data, it brings
all the data from the drop down lists instead of just importing the
one that is selected. For example, one column has drop down list to
select from 10 seasons. Even though Easter is selected, the imported
table has 10 rows. It is important for the users to have the drop down
columns to make their data entry easier. Does any one has any idea how
to resolve this issue?

 

[Jeanette Cunningham]

Raj,
fix the problem in excel before you import the worksheet.
Use some functions in excel to copy the users selection for each record for
each list to hidden columns.
Use a function which will copy just the user's choice.
If you need help with this part, ask in the excel discussion group.
Once you have this working, then you import the data from the hidden columns
instead of the drop down list columns.


Jeanette Cunningham