I have a list of Customer Numbers in Excel that I am trying to find a match in SQL Server 2000. I am looking for a way to link SQL to the spreadsheet. Such as below:
Can this be done with SQL Server 2000? Any ideas of other methods. Thanks.
SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\xltest.xls;Extended Properties=Excel 8.0')...[Customers$]