| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Excel Worksheet Functions | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
| Copy recordset from an Access "make table" query | Excel Programming | |||
| Linking a table in Access to a table in Excel using MS Query | Excel Programming | |||
Linear Mode
