ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy a table from Access into 2 columns (https://www.excelbanter.com/excel-programming/323972-copy-table-access-into-2-columns.html)

Tran Hong Quang

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



All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com