Error on Combox populate

[bssm]

Hi I am trying to populate a word userform combobox with data from an external excel file:

I keep getting a Syntax error on the FROM clause, I have no idea why?

Thanks

Please Login or Register  to view this content.

[bssm]

So I seem to have got round the syntax problem with from, now I am getting the error 'Syntax Error in query Sale Monies In'.
I believe it may be the naming of my links but unsure how to reference.

I am trying to populate a combobox from an exceMy setup is

Excel Workbook (CS Values)it contains one worksheet called Description, there is a table (table also named description) it has four headers:

Sale Monies In
Sale Monies Out
Purchase Monies In
Purchase Monies Out

I am trying to populate my combobox (MoniesInDescription) with the values from Sale Monies In

Is my connection naming wrong?

Please Login or Register  to view this content.