Get Access Data into Excel

  • Thread starter Thread starter fi.or.jp.de
  • Start date Start date
F

fi.or.jp.de

Hi All,

I am using excel macro to get data from access database.

My sql query gives me 5 records or more than that.

I am able to pull it different cells.

But I want all the 5 results in single cell.

Please help
 
im not exactly sure what your trying to do, but maybe something like this
will do the trick

dim accval as string

accval=rs!:XXX

rs.movenext

accval=accval & " " & rs!:xxx

loop it till rs.eof=true

hth

dmoney
 
Back
Top