Help: Import Access Data to link to Combo Box

[RDMRDM]

I have a table in Access 2003 that has combo fields to allow me to select the field I need. For example, the combo box has Yes, No, and Maybe as the 3 choices. When I import data from Excel, even though the field has Yes, No, and Maybe in Excel, I am required to reselect the Combo box field for each record. I believe this is because the the record is bound. For example, the master table is called Contacts. The field in Contacts table is named "Housing". This field is being looked up in another table named "Item_Housing". Here is the row source field in the contacts table. SELECT DISTINCTROW Item_Housing.* FROM Item_Housing ORDER BY Item_Housing.Housing;

Question is, is there a way I can import this data and have it automatically select the combo box option from the choices based on the data I imported since they are the same field name?

Or if you know of a better way to handle this using combo boxes, let me know. I basically have a form where the users will select their choices. However, they already have a lot of records from Excel that I wanted to import into this database. Thanks in advance for your help.

 

[kjv1611]

Sounds to me like you need to have the form import the Excel spreadsheets, and then run a query to only select what is needed from the newly created tables, or either go back and delete the unnecessary data.

One other way may be to use MS Query, but I'll not be much help with that one, I think, as I'm trying to get more used to that myself.

With the first option, you'd have a few different ways of doing it. If you have a standardized file naming scheme and a certain folder to import from, then you may can do it all just with the button press - otherwise, you may have some additional coding to do (such as being able to find the files).

--

"If to err is human, then I must be some kind of human!" -Me