Hi..........., </o>We know Microsoft Office Products especially Microsoft Office 2003 Excel By this product we can convert any web sites pages to SQL DateBase 20005 (.MDF) AS New Web Query ?.. Following these procedures: </o> 1- Open Microsoft Office 2003 Excel 2- Go to menu bar Data Tool Button 3- Import External data 4- New web query 5- Pop up small window appear 6- Write any web site (URL) in address bar 7- And press go 8- it is now the excel became like internet explorer tool (Browser Tool).it is showing web site contents in a small window 9- you will see small yellow arrow symbol beside the browser window it is for data block it 10- Click this yellow arrow for select any table you want it. the arrow symbol will change to green right symbol. 11- And click import. 12- it is show pop up window to ask you where do you want to put the data ? Existing in worksheet option or in a new worksheet option. 13- After finishing the data in worksheet processing save the file as (mydata.xls) extension. 14- Go to SQL Server 2005 Management Studio and using Import /Export tool it is comes as ( DTS) Data Translation Services with (SSMS-Client Tool). 15- To Import from data source Microsoft excel (97-2003) from the file path (from local). Where you put the file (mydata.xls). 16 ?and finally complete import or export procedure as you know as sql developer 17- if you import one sheet in your work book sheets you will see one data base object it is one table with the same sheet name. And if you import with more sheets in worksheets the import processing will creates more tables without using create table for (Database Object) that is for SQL Server Admin. Tasks as full Database Create Permissions not user permission. Or without attachment (.mdf ) . 18- As SQL language programming you must mapping (matching) the fields properties Between data source and data targetin order to work very well without Data Fields Error.... It is very easy way to collection more data from any Web Sites Pages As Data source For us without using anySQL Script Langauge . </o> Thanks Falah G.Salih </o>
Common practice for years now is to export from Excel as CSV then import into SQL Server. Works very well and the *.csv files are easy to backup in case you ever need them again.
Thanks wisemxfor reply yes i know that .... but from those procs. we canimport from any web site page (Documnets ) like ( html) docs. (.asp) and (.php) and (.aspx) to sql databse like html ------------> excel).xls-------->sql dta like php------------->excel-------->sql data asp----------------->excel--------->sql data aspx----------------->excel--------->sql data by using Browsing tool it is comes with excel as new web query Thanks again Falah G.S
