Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
select * from openrowset('MSDASQL', 'DSN=Visual FoxPro Tables; SourceDB= \\MYSERVER\FOLDER\; SourceType=DBF', 'select * from dbfTable')
EXEC sp_addlinkedserver MyExcel, 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\ee\test1_work.xls', NULL, 'Excel 5.0;' GO --Set up login mappings (just ADMIN - jet wants something). EXEC sp_addlinkedsrvlogin MyExcel, FALSE, NULL, Admin, NULL GO --List the tables in the linked server (these are the worksheet names). EXEC sp_tables_ex MyExcel GO select * from myexcel...Sheet1$ GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.