Importing Excel file to table

[infact]

I imported an Excel file into table, ran query, ran form from query and the first field has a drop down box format.
This must have been set up in the Excel file like this but doesn't show up in the table, only when I run the form. How can I remove this ?
Thanks.

 

[scottyjohn]

Perhaps autofilter in excel was switched on. Go to the original sheet and then menu option Data/Autofilter. If its checked uncheck it and then re-import the sheet

John
ski_69@hotmail.com

 

[infact]

HELP! It's still doing it. All the columns in the Excel file had the autofilter. I clicked to remove the check next to autofilter in DATA/AUTOFILTER. Could there possibly be some vba coding behind the scenes that forces this even though it apparently gets deactivated through the menu command ?