Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access/excel ado via vba
Hi there
Are the following pieces of code equivalent, especially in terms of performance? I'm trying to summarize a huge Access database for further analysis in Excel and need to improve efficiency of data transfer between the two apps as far as possible ... I'd appreciate any ideas (1) strSQL = "SELECT * FROM Customers" rsData.Open strSQL, cnSrc (2) strSQL = "SELECT * INTO [Excel 8.0;Database=C:\book1.xls].[Sheet1] FROM Customers" cnSrc.Execute strSQL I can't judge this for myself (yet), since the second procedure isn't returning any records ... Is this line of enquiry worth pursuing? Best regards Loane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
access--excel--access | Excel Programming | |||
How to access ACCESS from Excel! | Excel Programming |