| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data From Excel Range To Existing Access Table
Greetings,
I have an excel workbook containing a range which has a single row of data ("rng_Data" in range C1:C4). I would like to be able to have some code that will allow me to push a button from Excel and have the range of data uploaded and appended to the bottom of an existing table in an existing Access database. Assume database is called "Database.mdb" and the table is called "Table1". The fields in the Access table have already been defined and match up with the number of data points in the range. Could someone help with some code that would transfer this data. Thanks. Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| How to convert existing Excel List into a table in Access? | New Users to Excel | |||
| Transfer to an existing Access Table | Excel Discussion (Misc queries) | |||
| vb code to export data into existing Access table | Excel Programming | |||
| Excel Range to Access Table | Excel Programming | |||
Threaded Mode
