importing a query from access to word document table

[Bren]

When importing data from an access query to a word document table is there anyway to maintain currency formatting?

If not,

doctable.Column (2) Select
MyWordApp.Selection.MoveRight Unit:=wdCharacter, _
Count:=1, Extend:=wdExtend
MyWordApp.Selection.Cells.AutoFit

I can align right, but I don't know how to create a currency format with properties available to word tables.