| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retreiving data from Excel spreadsheet through ADODB
Hi,
I am using the ADO to retreive data from one worksheet from one book and into another book. I used sqSQL for the sheet search: rsdata.Open szSQL, ... where szSQL = "SELECT * FROM [Combined TG and TN$]" The sheet name from the book is "Combined TG and TN". Is there any way to format this so that this can be recognized? I know I should not be using long names with spaces, but I am not allowed to change the name. Thanks, Roel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dead links retreiving data? | Links and Linking in Excel | |||
| Retreiving font when matching data from one worksheet to another | Excel Discussion (Misc queries) | |||
| Retreiving TABNAME from within a spreadsheet | Excel Discussion (Misc queries) | |||
| Export from Excel to Access ADODB | Excel Programming | |||
| Using ADODB to read data out of another excel file | Excel Programming | |||
Threaded Mode
