| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I insert 4000 rows of Excel data into a sql database
I have an Excel app that I want to place a button on that would allow the user to replace the contents of a sql database table with updated excel data on a sheet(b2:e4125). I can get it to clear the table and upload the data row by row but it bombs after 42 rows. How can I update the sql table all at once. Is there away to put the excel data in an ACCEPTABLE array for the values piece of the sql insert into command to work. Thankyou? skaty
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have 4000+ rows in a worksheet, how to delete 100's at a time? | Excel Worksheet Functions | |||
| How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
| Modifying data in excel containing 4000+ formulas | Excel Worksheet Functions | |||
| What is quickest way to insert 4000 hyperlink documents? | Excel Worksheet Functions | |||
| Excel as relational database - data rows | Excel Worksheet Functions | |||
Hybrid Mode
