How to import a table on a Web page to Excel? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 09.11.2005 09:24:24 Hello How to import a table on a Web page to Excel? Columns in the table are delimited by several spaces, not by a htm table tag.

Re: How to import a table on a Web page to Excel? "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> 10.11.2005 04:25:15 fist use < data-get>external data (importdata) using a webquery into excel then data-texttocolumn using space as delimiter you must know the no. of the table in the webpage which can be found out from the source html page counting <table> tag or by trial and error -- remove $$$ from email addresss to send email ========================= "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... [Quoted Text] > Hello > How to import a table on a Web page to Excel? Columns in the table are > delimited by several spaces, not by a htm table tag. > >

Re: How to import a table on a Web page to Excel? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 10.11.2005 07:55:37 The table in the webpage looks as a table, but it is a text with columns in the table delimited by several spaces, not by a htm table tag. Therefore, the no. of the table cannot be found out from the source html page counting <table> tag, can be? The table is between other text. "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:%23QKbC7a5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl... [Quoted Text] > fist use < data-get>external data (importdata) using a webquery into excel > then > data-texttocolumn using space as delimiter > > you must know the no. of the table in the webpage which can be found out > from the source html page counting > <table> tag or by trial and error > -- > remove $$$ from email addresss to send email > > ========================= > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > Hello > > How to import a table on a Web page to Excel? Columns in the table are > > delimited by several spaces, not by a htm table tag. > > > > > >

Re: How to import a table on a Web page to Excel? "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> 10.11.2005 08:42:21 if this is the only table try checking <only tables> the second item under 2 of the dialog box <new web query> "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message news:#DSykwc5FHA.620[ at ]TK2MSFTNGP12.phx.gbl... [Quoted Text] > The table in the webpage looks as a table, but it is a text with columns in > the table delimited by several spaces, not by a htm table tag. Therefore, > the no. of the table cannot be found out from the source html page counting > <table> tag, can be? The table is between other text. > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: > news:%23QKbC7a5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl... > > fist use < data-get>external data (importdata) using a webquery into excel > > then > > data-texttocolumn using space as delimiter > > > > you must know the no. of the table in the webpage which can be found out > > from the source html page counting > > <table> tag or by trial and error > > -- > > remove $$$ from email addresss to send email > > > > ========================= > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > > Hello > > > How to import a table on a Web page to Excel? Columns in the table are > > > delimited by several spaces, not by a htm table tag. > > > > > > > > > > > >

Re: How to import a table on a Web page to Excel? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 10.11.2005 09:07:30 Clicking <Click to select this table> in the dialog box <new web query> selects all text on the page, not just the table. There are other tables (with columns delimited by spaces)separated by text on this page. I need the other tables too. "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:ur2tqKd5FHA.1416[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > if this is the only table try checking <only tables> the second item under > 2 of the dialog box <new web query> > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > news:#DSykwc5FHA.620[ at ]TK2MSFTNGP12.phx.gbl... > > The table in the webpage looks as a table, but it is a text with columns > in > > the table delimited by several spaces, not by a htm table tag. Therefore, > > the no. of the table cannot be found out from the source html page > counting > > <table> tag, can be? The table is between other text. > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > ÓÌÅÄÕÀÝÅÅ: > > news:%23QKbC7a5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl... > > > fist use < data-get>external data (importdata) using a webquery into > excel > > > then > > > data-texttocolumn using space as delimiter > > > > > > you must know the no. of the table in the webpage which can be found out > > > from the source html page counting > > > <table> tag or by trial and error > > > -- > > > remove $$$ from email addresss to send email > > > > > > ========================= > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > > > Hello > > > > How to import a table on a Web page to Excel? Columns in the table are > > > > delimited by several spaces, not by a htm table tag. > > > > > > > > > > > > > > > > > > > >

Re: How to import a table on a Web page to Excel? "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> 11.11.2005 03:40:13 in that case checking <only table> in new webquery window should be ok for you "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message news:uSnpvYd5FHA.3880[ at ]TK2MSFTNGP12.phx.gbl... [Quoted Text] > Clicking <Click to select this table> in the dialog box <new web query> > selects all text on the page, not just the table. There are other tables > (with columns delimited by spaces)separated by text on this page. I need the > other tables too. > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: > news:ur2tqKd5FHA.1416[ at ]TK2MSFTNGP09.phx.gbl... > > if this is the only table try checking <only tables> the second item > under > > 2 of the dialog box <new web query> > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > news:#DSykwc5FHA.620[ at ]TK2MSFTNGP12.phx.gbl... > > > The table in the webpage looks as a table, but it is a text with columns > > in > > > the table delimited by several spaces, not by a htm table tag. > Therefore, > > > the no. of the table cannot be found out from the source html page > > counting > > > <table> tag, can be? The table is between other text. > > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > > ÓÌÅÄÕÀÝÅÅ: > > > news:%23QKbC7a5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl... > > > > fist use < data-get>external data (importdata) using a webquery into > > excel > > > > then > > > > data-texttocolumn using space as delimiter > > > > > > > > you must know the no. of the table in the webpage which can be found > out > > > > from the source html page counting > > > > <table> tag or by trial and error > > > > -- > > > > remove $$$ from email addresss to send email > > > > > > > > ========================= > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > > news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > > > > Hello > > > > > How to import a table on a Web page to Excel? Columns in the table > are > > > > > delimited by several spaces, not by a htm table tag. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

Re: How to import a table on a Web page to Excel? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 11.11.2005 06:16:49 Clicking <Click to select this table> in new WebQuery window imports all text, not only tables, without separating to columns. "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:OciYEzn5FHA.2020[ at ]TK2MSFTNGP10.phx.gbl... [Quoted Text] > in that case checking <only table> in new webquery window should be ok for > you > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > news:uSnpvYd5FHA.3880[ at ]TK2MSFTNGP12.phx.gbl... > > Clicking <Click to select this table> in the dialog box <new web query> > > selects all text on the page, not just the table. There are other tables > > (with columns delimited by spaces)separated by text on this page. I need > the > > other tables too. > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > ÓÌÅÄÕÀÝÅÅ: > > news:ur2tqKd5FHA.1416[ at ]TK2MSFTNGP09.phx.gbl... > > > if this is the only table try checking <only tables> the second item > > under > > > 2 of the dialog box <new web query> > > > > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > news:#DSykwc5FHA.620[ at ]TK2MSFTNGP12.phx.gbl... > > > > The table in the webpage looks as a table, but it is a text with > columns > > > in > > > > the table delimited by several spaces, not by a htm table tag. > > Therefore, > > > > the no. of the table cannot be found out from the source html page > > > counting > > > > <table> tag, can be? The table is between other text. > > > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > > > ÓÌÅÄÕÀÝÅÅ: > > > > news:%23QKbC7a5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl... > > > > > fist use < data-get>external data (importdata) using a webquery into > > > excel > > > > > then > > > > > data-texttocolumn using space as delimiter > > > > > > > > > > you must know the no. of the table in the webpage which can be found > > out > > > > > from the source html page counting > > > > > <table> tag or by trial and error > > > > > -- > > > > > remove $$$ from email addresss to send email > > > > > > > > > > ========================= > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > > > news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > > > > > Hello > > > > > > How to import a table on a Web page to Excel? Columns in the table > > are > > > > > > delimited by several spaces, not by a htm table tag. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

Re: How to import a table on a Web page to Excel? "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> 11.11.2005 07:52:34 find the delimiters they are using usually commas or some other signs. hightlight the data in the first column only then use data-text to columns and follow the wizard. From your earlier message it looks the delimiter are spaces then in the step 2 uncheck all the delimiters and check only <space>. then you will see in the table below that the vertical lines are inserted at proper places and then you can finish it. hope you succeed. -- remove $$$ from email addresss to send email ============================== "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message news:enVyBeo5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... [Quoted Text] > Clicking <Click to select this table> in new WebQuery window imports all > text, not only tables, without separating to columns. > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: > news:OciYEzn5FHA.2020[ at ]TK2MSFTNGP10.phx.gbl... > > in that case checking <only table> in new webquery window should be ok for > > you > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > news:uSnpvYd5FHA.3880[ at ]TK2MSFTNGP12.phx.gbl... > > > Clicking <Click to select this table> in the dialog box <new web query> > > > selects all text on the page, not just the table. There are other tables > > > (with columns delimited by spaces)separated by text on this page. I need > > the > > > other tables too. > > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > > ÓÌÅÄÕÀÝÅÅ: > > > news:ur2tqKd5FHA.1416[ at ]TK2MSFTNGP09.phx.gbl... > > > > if this is the only table try checking <only tables> the second item > > > under > > > > 2 of the dialog box <new web query> > > > > > > > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > > news:#DSykwc5FHA.620[ at ]TK2MSFTNGP12.phx.gbl... > > > > > The table in the webpage looks as a table, but it is a text with > > columns > > > > in > > > > > the table delimited by several spaces, not by a htm table tag. > > > Therefore, > > > > > the no. of the table cannot be found out from the source html page > > > > counting > > > > > <table> tag, can be? The table is between other text. > > > > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > > > > ÓÌÅÄÕÀÝÅÅ: > > > > > news:%23QKbC7a5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl... > > > > > > fist use < data-get>external data (importdata) using a webquery > into > > > > excel > > > > > > then > > > > > > data-texttocolumn using space as delimiter > > > > > > > > > > > > you must know the no. of the table in the webpage which can be > found > > > out > > > > > > from the source html page counting > > > > > > <table> tag or by trial and error > > > > > > -- > > > > > > remove $$$ from email addresss to send email > > > > > > > > > > > > ========================= > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > > > > news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > > > > > > Hello > > > > > > > How to import a table on a Web page to Excel? Columns in the > table > > > are > > > > > > > delimited by several spaces, not by a htm table tag. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

Re: How to import a table on a Web page to Excel? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 11.11.2005 10:26:30 How to import tables only, not all text? Clicking <Click to select this table> in new WebQuery window imports all text, not only tables. "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:%23N6mxap5FHA.1032[ at ]TK2MSFTNGP11.phx.gbl... [Quoted Text] > find the delimiters they are using usually commas or some other signs. > hightlight the data in the first column only > then use data-text to columns and follow the wizard. From your earlier > message it looks the delimiter are spaces > then in the step 2 uncheck all the delimiters and check only <space>. then > you will see in the table below that the vertical lines are inserted at > proper places and then you can finish it. > > hope you succeed. > > > -- > remove $$$ from email addresss to send email > ============================== > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > news:enVyBeo5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > Clicking <Click to select this table> in new WebQuery window imports all > > text, not only tables, without separating to columns. > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > ÓÌÅÄÕÀÝÅÅ: > > news:OciYEzn5FHA.2020[ at ]TK2MSFTNGP10.phx.gbl... > > > in that case checking <only table> in new webquery window should be ok > for > > > you > > > > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > news:uSnpvYd5FHA.3880[ at ]TK2MSFTNGP12.phx.gbl... > > > > Clicking <Click to select this table> in the dialog box <new web > query> > > > > selects all text on the page, not just the table. There are other > tables > > > > (with columns delimited by spaces)separated by text on this page. I > need > > > the > > > > other tables too. > > > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > > > ÓÌÅÄÕÀÝÅÅ: > > > > news:ur2tqKd5FHA.1416[ at ]TK2MSFTNGP09.phx.gbl... > > > > > if this is the only table try checking <only tables> the second > item > > > > under > > > > > 2 of the dialog box <new web query> > > > > > > > > > > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > > > news:#DSykwc5FHA.620[ at ]TK2MSFTNGP12.phx.gbl... > > > > > > The table in the webpage looks as a table, but it is a text with > > > columns > > > > > in > > > > > > the table delimited by several spaces, not by a htm table tag. > > > > Therefore, > > > > > > the no. of the table cannot be found out from the source html page > > > > > counting > > > > > > <table> tag, can be? The table is between other text. > > > > > > "R.VENKATARAMAN" <vram26[ at ]vsnl$$$.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ > > > > > ÓÌÅÄÕÀÝÅÅ: > > > > > > news:%23QKbC7a5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl... > > > > > > > fist use < data-get>external data (importdata) using a webquery > > into > > > > > excel > > > > > > > then > > > > > > > data-texttocolumn using space as delimiter > > > > > > > > > > > > > > you must know the no. of the table in the webpage which can be > > found > > > > out > > > > > > > from the source html page counting > > > > > > > <table> tag or by trial and error > > > > > > > -- > > > > > > > remove $$$ from email addresss to send email > > > > > > > > > > > > > > ========================= > > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > > > > > news:#WI#g9Q5FHA.724[ at ]TK2MSFTNGP14.phx.gbl... > > > > > > > > Hello > > > > > > > > How to import a table on a Web page to Excel? Columns in the > > table > > > > are > > > > > > > > delimited by several spaces, not by a htm table tag. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >