dimanche 31 janvier 2016

How can I delete these rows and columns that were created from excel?

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.

enter image description here

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire