I'm probably going about it the wrong way. I want EVERYTHING from Table_2, which should make it easy. Is there a way I can do it wholesale: copy ALL of Table_2 and just make it part of Table_1? I feel like what I want to do should only take 1 second to execute programmatically, not 20 minutes. I suspect it's because I'm doing a couple hundred iterations of. In your spreadsheet, select the number of rows that you’d like to add. To use this method, first, open your spreadsheet with Microsoft Excel. One way to add multiple rows in Excel is by using an option in Excel’s context menu. Occasionally, Table_2 will have a couple hundred entries, which will literally take 20 minutes to complete. Insert Multiple Rows in Excel With a Right-Click Menu Option. This works great if Table_2 (new entries) only has a dozen entries. My code (correctly) copies data from Table_2 to Table_1: For Each temprow in Table_2.ListRows The result is that Table_2 only pulls new data. I have VBA code that copies Table_2 to Table_1 and then updates the connection string for Table_2 to not include entries with dates within the range of Table_1. It is kept separate because it (1) shortens the query time in Table_2 and (2) has some programmatic edits. Table_1 is a table (ListObject) that acts as a collective list of entries. Table_2 is a temporary table (ListObject) that queries a database for entries using data connection.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |