| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fast way to insert data from database
Just my $0.02...
I have recently begun copying the entire recordset to a blank workshee and then stripping off everything I don't need. Using: Range("A1").CopyFromRecordset objRS You can delete the headers and other stuff and do formatting on a muc larger scale (i.e. by column rather than by individual cell). Yo could even set up a sheet with all of your formatting and then past the recordset into it. -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need really fast method to sort data for my part numbering spread | Excel Discussion (Misc queries) | |||
| Help finding a fast way to cross reference data between sheets??? | Excel Discussion (Misc queries) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Bar Graph - Values from one cell, data from another FAST formating | Excel Discussion (Misc queries) | |||
| fast way to make reports from a database | Excel Programming | |||
![kkknie[_54_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
