3 fields into 1 excel cell 1

[mavog]

Hi, could anyone tell me how to do this:
I have 3 fields in my table that I want to export/concatenate into 1 excel cell in a spreadsheet. Unforunately I have no idea how to go about this. Does anybody have any suggestions for me?

 

[combo]

To speed up export and minimise operations in excel I would create a query with concatenated fields and export it directly to excel file:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query_name", "Path&File.xls", True

 

[mavog]

Thanx for the help, but how do I create a query that concatenates fields?

 

[combo]

Having Table1 with [Field1], [Field2], [Field3], [Field4], you can create new query (say Query1). In project view in one of query fields concatenate three of fields:
ThreeFields: [Field1] & [Field2] & [Field3]
and put Field4 as second field in query.
Now it is possible to use DoCmd... for Query1 instead of Table1.

combo