Get Access Data into Excel

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
 
D

dmoney

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get results from Access Database. 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Help with Access query from Excel 3
Query Data in Excel S/S from Access DB 2
Copying jpeg image data date into excel 0
Excel & Access Tables 4
Problem with external data and #reference error 2
Access #Error & Excel Pivot 0

Top