Importing data from Excel with drop-down list

[horhif]

Hi,

I have a Access DB created. I have a field, which is a dropdown list. The users can go in to a form and manually create a record into the table etc.

However, i've some data that I'd like to import into the DB.

This data is in Excel.

When i import the data, everything is fine but the column that has the information for the dropdown field does not import.

so to clarifiy, the field in the DB is a dropdown list.

the field in the Excel data is just a plain text entry.

is there somehow i can import this data?

thanks

 

[DavidAtWork]

How are you importing this data, are you trying to import into an existing table, if so then I'd check the field data type for the field that is failing. May be better to import into a new table and then run an append query to get it into the right table, that way you can modify/transform any incorrect data types.

David

 

[horhif]

that worked. thanks very much!

 

[BeaMaria]

Hi there,

I was having the same problem as horhif, so I went through as advised and input the data into a new table, creating lookup columns for the data so it matched the first table. I then subsequently attempted an append query in order to add the new records to the first table.

However, it comes up with a box saying 'An INSERT INTO query cannot contain a multi-valued field'.

Does anyone know how to do an append query with multi-value fields? Or how to get around this?

Thanks!

 

[CJ_London]

Sorry to say the simple answer is to not use multivalue fields - you will find in time they cause more problems than they solve.

If you need to have multivalues, I would do it the standard way of having a separate table with your values.