Hi there,
I hope someone can help me here.
What I'd like to attempt to accomplish is bring together two spreadsheets of data without the use of Access by using SQL in VB code.
I already update a report of mine using CreateObject("ADODB.Connection") and open a record set using a query string.
I'd like to do something along the lines of the following... where excelfile_2 has the latest status of my records.
[VBA]SELECT [Sheet1$].[ID], ["Provider=Microsoft.Jet.OLEDB.4.0;Data Source=exelfile_2.xls;Extended Properties=""Excel 8.0;HDR=YES"";sheet1$].[Status]
FROM [Sheet1$]
INNER JOIN [Sheet1$].[ID] ON ["Provider=Microsoft.Jet.OLEDB.4.0;Data Source=exelfile_2.xls;Extended Properties=""Excel 8.0;HDR=YES"";Sheet1$].[ID] = [Sheet1$].[ID][/VBA]
Any pointers will be much appreciated....