I have this doubt. I have charged a sheet of excel from SQL Server 2008 and this shows all the data what contains the sheet. I wish to have the data that I want and I can save these records in a some table. But I need to know How can I delete all the data that I dont need rows and columns of the sheet. Please I need you can help me.
I have it that I allow me import my sheet of Excel
select * into #TBL_DATA from openrowset('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0; Database=C:\Microsoft\siac.xls; HDR=YES; IMEX=1',
'select * from [Campo23$]')
This the image as shows in the query.
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire