| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Access Records
Hi
The following can extract data from one row in an Access table; (Connection and Recordset declared) ThisWorkbook.Sheets(3).Cells(h, i).Value = rs.Fields(i).Value But does Access has something similar to Cells(h,i) to enable extracting data of a whole table using a 'For Loop'. Can someone help? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet | Excel Programming | |||
| Updating Records from MS Access | Excel Discussion (Misc queries) | |||
| Updating records in an Access DB | Excel Programming | |||
| Getting records from Access 97 to Excel 97 | Excel Programming | |||
| How to Get records from a query in access and put them in Excel | Excel Programming | |||
Threaded Mode
