How can i Display data Query

Hi,


I am trying to run a query from an orders database with the suppliers names in a combo box.

When the query runs it does not retrieve the supplier's name but displays a number. I'm not even sure where this number is retrieved from as it is not the SupplierID number in the underlying table.

I'm sure that the problem can be resolved easily but I don't have the knowledge skills to resolve it.

any help would be greatly appreciated.
Thanks

You want to convert the excel file to CSV file.
You can simply do one thing open the spreadsheet in excel and save it as csv.

If you have it linked Access as an Excel spreadsheet then create a macro using the TransferSpreadsheet command.