Retreiving data from Excel spreadsheet through ADODB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Roel (roel_at_teragren.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 14:26:35 -0800

Hi,

    I am using the ADO to retreive data from one work*** from one book and
into another book. I used sqSQL for the *** search:

    rsdata.Open szSQL, ...

where szSQL = "SELECT * FROM [Combined TG and TN$]"

    The *** 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

Quantcast