Last night, as I was sleeping,
I dreamt – marvelous error! –
that I had a beehive
here inside my heart.
And the golden bees
were making white combs
and sweet honey
from all my old failures.
(Antonio Machado, translated by Robert Bly)
Last night I had a dream—
a blessed illusion it was—
I dreamt of a hive at work
deep down in my heart.
Within were the golden bees
straining out the bitter past
to make sweet-tasting honey,
and white honeycomb.
(Antonio Machado, translated by Alan S. Trueblood)
Last night while sleeping
I dreamt, – blessed illusion!
that a beehive
within my heart;
and the golden bees
were making,
from my bitter disappointments,
white wax and sweet honey.
(Antonio Machado, translated by Chris Cavanagh)
Anoche cuando dormía
soñé, ¡bendita ilusión!,
que una colmena tenía
dentro de mi corazón;
y las doradas abejas
iban fabricando en él,
con las amarguras viejas
blanca cera y dulce miel.
The full text, in English and in Spanish, is here at Goodreads. Thanks to Joanna Hastings for taking note of it in a post to Facebook.
Edward Vielmetti's Wordpress weblog 
I like the first one best. Although it may not be the most literal translation.
Here’s one more translation, from author Robert Moss (“The Secret History of Dreaming”)
http://mossdreams.blogspot.com/2011/07/in-beehive-of-heart.html
Last night as I was sleeping
I dreamed – blessed illusion! –
I had a beehive
inside my heart
and golden bees
were working inside
to turn old regrets
into beeswax and sweet honey
A lovely, inspiring passage! I like the the Bly translation best.
Two more translations just for fun – by machine this time – the first is soooo close to working:
Last night he slept
I dreamed, blessed illusion!,
a hive had
within my heart;
and the golden bees
were making it,
with the old bitterness
white wax and sweet honey.
–google translate
Last night when it slept I dreamed, blessed illusion! , that a beehive had within my heart; and the sea breams bees they were making in him, with the old woman bitterness white wax and candy honey.
–Altavista babelfish
Reblogged this on Chris Cocca and commented:
I was writing a poem about bees, and a friend shared these with me. They are lovely.