View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tran Hong Quang Tran Hong Quang is offline
external usenet poster
 
Posts: 3
Default Copy a table from Access into 2 columns

Hi,
I have a big tables in Ms Access. I writ a VBA code from Ms Access to
output these records to Ms Excel. I am using:

..Range("B1").CopyFromRecordset rstTelBill

Each record is on one row of Excel. How can I copy records into 2 columns
like this:

Record1 Record2
Record3 Record4
............ ............

Thank for help
Tran Hong Quang