query for importing table form the net

[ppc via AccessMonster.com]

Hi

Is it anyway possible to directly import a html table located on the net to
the access table.
Right now i am accessing that html page saving it locally and then importing
it to my access table by using criteria Import html.

regds,

prasanna

 

[Jerry Whittle]

In Access 2003:

On the menu go up to Files, Get External Data, Import.

At the first dialog box change the Files of Type dropdown to HTML Documents.

Type in the entire URL in the File Name box.

Press Import and see what happens.

 

[ppc via AccessMonster.com]

Hi
I tried as told.But its not working.It iust stops at
http://www.bseindia.com/mktlive/
When the exact path given in file name as :
http://www.bseindia.com/mktlive/ind...3523.67&dateheader=Tuesday,+December+11,+2007


regds

prasanna

In Access 2003:

On the menu go up to Files, Get External Data, Import.

At the first dialog box change the Files of Type dropdown to HTML Documents.

Type in the entire URL in the File Name box.

Press Import and see what happens.

Hi

[quoted text clipped - 6 lines]

prasanna