| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace SQL Table with Excel data
I have a SQL database with a table that I need to periodically replace with
data from an Excel spreadsheet. I wrote a proceedure using ADO to delete each record one by one - then adding each record one by one, but it takes forever. Is there a better way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: How do I replace the default color table? | Excel Discussion (Misc queries) | |||
| Pivot Table with Data replace error | Excel Discussion (Misc queries) | |||
| Pivot table with data replace error. | Excel Discussion (Misc queries) | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Replace all Pivot table data fields using VBA | Excel Programming | |||
Threaded Mode
