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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retreiving data from Excel spreadsheet through ADODB
What do you mean by 'reorganize'? You can alias the table name to make
you queries more concise e.g. if you wanted to select columns named Col1 and Col2 from your 'Combined TG and TN' sheet: SELECT T1.Col1, T1.Col2 FROM [Combined TG and TN$] AS T1 WHERE T1.Col1 100 BTW in the other workbook, are you creating a new sheet or appending to an existing sheet? To create a new sheet: SELECT T1.Col1, T1.Col2 INTO [Excel 8.0;database=C:\MyOtherWorkbook.xls;].MyNewTable FROM [Combined TG and TN$] AS T1 To append to existing sheet 'MyTable': INSERT INTO [Excel 8.0;database=C:\MyOtherWorkbook.xls;].[MyTable$] SELECT T1.Col1, T1.Col2 FROM [Combined TG and TN$] AS T1 -- "Roel" wrote in message ... 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 |
Reply |
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 |