How to use a field with spaces in a recordset 1

[emik]

Hi,

I currently have a process to import an Excel file using the Transferspreadsheet method. The Excel file has fields with spaces, so the field names in my Access table must match (thus having spaces).

In the code for a field without spaces, the recordset is

test = currentdb.openrecordset("Select field FROM..etc.")

To reference it I use test!field

Now how could I do that for a field with spaces?

Thanks.

 

[TomCologne]

Use brackets, eg test![field with space]

TomCologne

 

[emik]

Thanks Tom, works great!