linking data from a web to access

T

thread

hi all,

i would like to link the tables coming from the web below(extract it
by view code)
does anyone have an example of an option to link the information
direcly to access?




<HTML>
<HEAD><TITLE>Location Database Reports</TITLE></HEAD>
<BODY BGCOLOR=#FFFFFF>
<H1><CENTER>Location Database Reports</CENTER></H1>
<HR>
To run a Location Database report follow the instructions below and
then press the "Submit Form" button.
<FORM METHOD=POST ACTION="loc_display.asp">
<HR>
Select what type of report you want:<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=page CHECKED> <B>Detail
Report:</B> Display <INPUT TYPE="text" SIZE=2 NAME="pg_size"
VALUE=1>
matching locations per screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=all> <B>Summary Report:</B>
Display all matching locations on one screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv1> <B>Extract Report with
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv> <B>Extract Report without
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv2> <B>Extract Report in
Microsoft Excel Format:</B> Display location data in a spreadsheet
showing all columns.&nbsp &nbsp <A HREF="locationSchema.asp">Show
Location Data Schema</A><P>

<HR>
Fill in all of the fields you want to query by. You can use the "%"
character as a wildcard character.
<P><P>
<TABLE BORDER=0 WIDTH=100%>
<P>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER>
<B>Status</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<SELECT NAME=loc_status>
<OPTION VALUE>
<OPTION SELECTED VALUE=C >CURRENT
<OPTION VALUE=P >PENDING
<OPTION VALUE=D >DELETED
</SELECT>
</TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Location Code</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=10 NAME="loc_code"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Type</B></TD>
<TD><SELECT NAME="loc_type">
<OPTION VALUE>
<OPTION SELECTED VALUE=D>FACILITY &nbsp &nbsp &nbsp &nbsp &nbsp
<OPTION VALUE=H>HOME

</SELECT></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Name</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=35 NAME="loc_sitename"></TD>

</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Country</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER><SELECT NAME="loc_country">
<OPTION SELECTED>

<OPTION>ANGOLA
<OPTION>ARGENTINA
<OPTION>AUSTRALIA
<OPTION>AUSTRIA
<OPTION>BANGLADESH
<OPTION>BARBADOS
<OPTION>BELARUS
<OPTION>BELGIUM
<OPTION>BOLIVIA
<OPTION>BRAZIL
<OPTION>BULGARIA
<OPTION>CANADA
<OPTION>CHILE
<OPTION>CHINA
<OPTION>COLOMBIA
<OPTION>CONGO
<OPTION>COSTA RICA
<OPTION>CROATIA
<OPTION>CZECH REPUBLIC
<OPTION>DEMOCRATIC REP OF CONGO
<OPTION>DENMARK
<OPTION>DOMINICAN REPUBLIC
<OPTION>ECUADOR
<OPTION>EGYPT
<OPTION>FINLAND
<OPTION>FRANCE
<OPTION>GEORGIA
<OPTION>GERMANY
<OPTION>GHANA
<OPTION>GREECE
<OPTION>GUAM
<OPTION>GUATEMALA
<OPTION>HONG KONG
<OPTION>HUNGARY
<OPTION>INDIA
<OPTION>INDONESIA
<OPTION>IRAQ
<OPTION>IRELAND
<OPTION>ISRAEL
<OPTION>ITALY
<OPTION>JAPAN
<OPTION>JORDAN
<OPTION>KAZAKHSTAN
<OPTION>KUWAIT
<OPTION>LATVIA
<OPTION>LEBANON
<OPTION>LITHUANIA
<OPTION>MALAYSIA
<OPTION>MALDIVES
<OPTION>MEXICO
<OPTION>MOROCCO
<OPTION>NETHERLANDS
<OPTION>NEW ZEALAND
<OPTION>NIGERIA
<OPTION>NORWAY
<OPTION>OMAN
<OPTION>PAKISTAN
<OPTION>PANAMA
<OPTION>PERU
<OPTION>PHILIPPINES
<OPTION>POLAND
<OPTION>PORTUGAL
<OPTION>PUERTO RICO
<OPTION>QATAR
<OPTION>ROMANIA
<OPTION>RUSSIA
<OPTION>SAUDI ARABIA
<OPTION>SERBIA
<OPTION>SINGAPORE
<OPTION>SLOVAKIA
<OPTION>SLOVENIA
<OPTION>SOUTH AFRICA
<OPTION>SOUTH KOREA
<OPTION>SPAIN
<OPTION>SRI LANKA
<OPTION>SWEDEN
<OPTION>SWITZERLAND
<OPTION>TAIWAN
<OPTION>TANZANIA
<OPTION>THAILAND
<OPTION>TURKEY
<OPTION>UKRAINE
<OPTION>UNITED ARAB EMIRATES
<OPTION>UNITED KINGDOM
<OPTION>UNITED STATES
<OPTION>URUGUAY
<OPTION>UZBEKISTAN
<OPTION>VENEZUELA
<OPTION>VIETNAM
<OPTION>YEMEN
</SELECT>
</TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Complete Address</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address1"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>State/Province</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=25 NAME="loc_state"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address2"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>City</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_city"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address3"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Zip Code</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_zip"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address4"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Phone</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_phone"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address5"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Fax</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_fax"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address6"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Time Zone</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER><SELECT NAME="loc_timezone">
<OPTION VALUE>
<OPTION VALUE>GMT-12:00 ENIWETOK, KWAJALEIN
<OPTION VALUE>GMT-11:00 MIDWAY ISLAND, SAMOA
<OPTION VALUE>GMT-10:00 HAWAII
<OPTION VALUE>GMT-09:00 ALASKA
<OPTION VALUE>GMT-08:00 PACIFIC TIME (US)
<OPTION VALUE>GMT-07:00 ARIZONA
<OPTION VALUE>GMT-07:00 MOUNTAIN TIME (US)
<OPTION VALUE>GMT-06:00 CENTRAL TIME (US)
<OPTION VALUE>GMT-06:00 MEXICO CITY
<OPTION VALUE>GMT-06:00 SASKATCHEWAN
<OPTION VALUE>GMT-05:00 BOGOTA, LIMA
<OPTION VALUE>GMT-05:00 EASTERN TIME (US)
<OPTION VALUE>GMT-05:00 INDIANA (EAST)
<OPTION VALUE>GMT-04:00 ATLANTIC TIME
<OPTION VALUE>GMT-04:00 CARACAS, LA PAZ
<OPTION VALUE>GMT-03:30 NEWFOUNDLAND
<OPTION VALUE>GMT-03:00 BRASILIA
<OPTION VALUE>GMT-03:00 BUENOS AIRES
<OPTION VALUE>GMT-02:00 MID-ATLANTIC
<OPTION VALUE>GMT-01:00 AZORIES, CAPE VERDE
<OPTION VALUE>GMT GREENWICH MEAN, LONDON
<OPTION VALUE>GMT MONROVIA, CASABLANCA
<OPTION VALUE>GMT+01:00 BERLIN, ROME, VIENNA
<OPTION VALUE>GMT+01:00 PARIS, MADRID
<OPTION VALUE>GMT+01:00 PRAGUE, WARSAW
<OPTION VALUE>GMT+02:00 ATHENS, HELSINKI
<OPTION VALUE>GMT+02:00 CAIRO
<OPTION VALUE>GMT+02:00 EASTERN EUROPE
<OPTION VALUE>GMT+02:00 HARARE, PRETORIA
<OPTION VALUE>GMT+02:00 ISRAEL
<OPTION VALUE>GMT+03:00 BAGHDAD, NAIROBI
<OPTION VALUE>GMT+03:00 MOSCOW, VOLGOGRAD
<OPTION VALUE>GMT+03:30 TEHRAN
<OPTION VALUE>GMT+04:00 ABU DHABI, MUSCAT
<OPTION VALUE>GMT+04:30 KABUL
<OPTION VALUE>GMT+05:00 ISLAMABAD, TASHKENT
<OPTION VALUE>GMT+05:30 BOMBAY, CALCUTTA
<OPTION VALUE>GMT+06:00 ALMATY, DHAKA
<OPTION VALUE>GMT+07:00 BANGKOK, HANOI
<OPTION VALUE>GMT+08:00 BEIJING, CHONGQING
<OPTION VALUE>GMT+08:00 HONG KONG, PERTH
<OPTION VALUE>GMT+09:00 TOKYO, OSAKA, SEOUL
<OPTION VALUE>GMT+09:30 ADELAIDE
<OPTION VALUE>GMT+09:30 DARWIN
<OPTION VALUE>GMT+10:00 BRISBANE, SYDNEY
<OPTION VALUE>GMT+10:00 GUAM, VLADIVOSTOK
<OPTION VALUE>GMT+10:00 HOBART
<OPTION VALUE>GMT+11:00 MAGADAN, SOLOMON IS.
<OPTION VALUE>GMT+12:00 FIJI, MARSHALL IS.
<OPTION VALUE>GMT+12:00 WELLINGTON, AUCKLAND
</SELECT></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address7"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Comments</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=35 NAME="loc_comments"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Organization</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=35 NAME="org_organiz"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Org Description</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=35 NAME="org_descript"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Org Sector</B></TD>

<TD ALIGN=LEFT VALIGN=CENTER><SELECT NAME="org_sector">
<OPTION SELECTED>

<OPTION>BROADBAND COMMUNICATIONS SECTOR
<OPTION>COMMERCIAL, GOVERNMENT AND INDUSTRIAL SOLUTIONS SECTOR
<OPTION>CONNECTED HOME
<OPTION>CORPORATE
<OPTION>FREESCALE SEMICONDUCTOR, FORMERLY A MOTOROLA COMPANY
<OPTION>GLOBAL TELECOM SOLUTIONS SECTOR
<OPTION>GOVERNMENT AND ENTERPRISE MOBILITY SOLUTIONS
<OPTION>INTEGRATED ELECTRONIC SYSTEMS SECTOR
<OPTION>METROWERKS
<OPTION>MOBILE DEVICES
<OPTION>NETWORKS
<OPTION>PERSONAL COMMUNICATIONS SECTOR
<OPTION>SEMICONDUCTOR PRODUCTS SECTOR
</SELECT></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Org Phone</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="org_phone"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Org Fax</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="org_fax"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Requestor ID</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_req_id"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Requester Name</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_req_name"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Requestor Phone</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_req_phone"></TD>
</TR>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Approver ID</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_userid"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Modified Date</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_update"></TD>
</TR>

<INPUT TYPE="HIDDEN" NAME="sql" VALUE="">
</TABLE>
<HR><CENTER>
<INPUT TYPE="submit" VALUE="Submit Form">
<INPUT TYPE="reset" VALUE="Clear Form">
<INPUT TYPE="submit" NAME="Action" VALUE="Logoff System">
</CENTER></FORM>
</BODY>
</HTML>
 
W

Wayne-I-M

Hi

This is a copy of a post I made some time ago. It will bring data from an
external DB into an access DB.

_________________________________

This gets asked quite a bit so I thought I would give one method. (sorry if
the english is not too good)

To import data from a table in an external database into (append) to a table
in your internal database.


This is not the only way to do this – there are other methods – the “cheatsâ€
I have given here you can either or not – I use them as I’m lazy and – in
this case – the end justifies the means (especially when the means are
deleted
after the end is accomplished?)


Names – In this I have used….


External Database - This is where the records are now
The records are in a table called tblOldExport


Internal Database - This is where I want them to be
tblInternalNewRecords - This the table in Internal Database where I want
the records go
-----------------------------------------
1 This is the 1st cheat – go to External Database and copy the table
containing the data you want to bring in.


2 Go to Internal Database and paste the table (structure only). Call it
tblImportAppend


3 Past the same table again (structure only) Call it tblInternalNewRecords


So you now have 2 empty copies of the table tblOldExport (but in your
Intenal Database) with new names.


4 Create a new query in your internal database (call it qryImportAppend).
Base this new query on tblImportAppend. Individually click each of the fields
so they all shown in the design grid.


5 Change the query to an Append Query. In the drop down list select
tblInternalNewRecords. If you have copied the tables correctly the fields in
the “Append To†row will fill in automatically. (You can change these update
to fields)


6 Create a new form in Internal Database.


7 Create a new button (call it cboImport)


8 Put this code on the OnClick event


Private Sub cboImport _Click()
Dim WayneIMPfile As TableDef
For Each WayneIMPfile In CurrentDb.TableDefs
If WayneIMPfile.Name = "tblImportAppend " Then
CurrentDb.TableDefs.Delete WayneIMPfile.Name
End If
Next
DoCmd.TransferDatabase acImport, "Microsoft Access", "Path to
ExternalDatabase.mdb", acTable, " tblOldExport ", " tblImportAppend "
DoCmd.SetWarnings False
DoCmd.OpenQuery " qryImportAppend "
DoCmd.SetWarnings True
CurrentDb.TableDefs.Delete "tblImportAppend"
End Sub


Notes on this code
1 Change the names to whatever you want. - I wouldn’t have WayneIMPFile –
unless …. :)
2 The 1st section just looks for and deletes tblImportAppend if it’s there
3 The next bit DoCmd.TransferDatabase is a standard way to bring in tables
to a DB (press F1 for more information)
4 The path to the MDB can be found by (another cheat).
Start – Run – Browse - Navigate to DB - Select open - Cut the path from the
run box and paste into code - Close run
5 Turn of warning
6 DoCmd.OpenQuery Runs the append query
7 Turn the warnings back on
8 Delete the table the code created (tblImportAppend)
9 End Sub – go and have a coffee


Note – if you look at the design of the Append Query it will look wrong - as
there is no table to base it on. Don’t worry this is normal. The code will
create the table, run the query then delete the table again (I tend to do
this as it’s just extra disk space).


Of course you can append the data to other tables and you don’t need to
append all fields. If you play around with the code and the Append you will
get it to do want you need.


I use this method quite often and have the validation process in the append
query – is text formatted correctly, are numbers right, are postcodes
formated so the post office will acept them, etc, etc. But the most
important validation I use is not importing records that are already in the
table. You can use a time/date stamp (field) in the external table and in
the append simple put something like
[TimeDateField] in the criteria row.


Good luck
 
6

'69 Camaro

Hi.
i would like to link the tables coming from the web below(extract it
by view code)
does anyone have an example of an option to link the information
direcly to access?

Sorry. Access doesn't support linking to a Web page through HTTP. However,
if you first download the Web page to your hard drive or your network, if
there's a suitable table structure, then Jet can use the HTML driver to link
to the Web page's table. Use the File -> Get External Data -> Link
Tables... menu and then navigate to the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
W

Wayne-I-M

Following on from Gunny's post - if it's not too late (ie. if you are just
starting to write a new DB) I have set up a link to an on line DB (frontpage)
using sql server.

I really did try using access :) and it "will" work but the amount of
"stuff" needed meant it was simply quicker to write a new sql DB and then use
an import/append to the access DB.
 
T

thread

On 15 , 14:53, Wayne-I-M <[email protected]>
wrote:
Hi Wayne,

the question is what should be done if the table is changing by the
link and it is only diffrent report how can i link dirrecly to the
runing report,the link i gave is the web extracting the reports but
the link its changing all the time
Hi

This is a copy of a post I made some time ago. It will bring data from an
external DB into an access DB.

_________________________________

This gets asked quite a bit so I thought I would give one method. (sorryif
the english is not too good)

To import data from a table in an external database into (append) to a table
in your internal database.

This is not the only way to do this - there are other methods - the "cheats"
I have given here you can either or not - I use them as I'm lazy and - in
this case - the end justifies the means (especially when the means are
deleted
after the end is accomplished?)

Names - In this I have used....

External Database - This is where the records are now
The records are in a table called tblOldExport

Internal Database - This is where I want them to be
tblInternalNewRecords - This the table in Internal Database where I want
the records go
-----------------------------------------
1 This is the 1st cheat - go to External Database and copy the table
containing the data you want to bring in.

2 Go to Internal Database and paste the table (structure only). Call it
tblImportAppend

3 Past the same table again (structure only) Call it tblInternalNewRecords

So you now have 2 empty copies of the table tblOldExport (but in your
Intenal Database) with new names.

4 Create a new query in your internal database (call it qryImportAppend).
Base this new query on tblImportAppend. Individually click each of the fields
so they all shown in the design grid.

5 Change the query to an Append Query. In the drop down list select
tblInternalNewRecords. If you have copied the tables correctly the fields in
the "Append To" row will fill in automatically. (You can change these update
to fields)

6 Create a new form in Internal Database.

7 Create a new button (call it cboImport)

8 Put this code on the OnClick event

Private Sub cboImport _Click()
Dim WayneIMPfile As TableDef
For Each WayneIMPfile In CurrentDb.TableDefs
If WayneIMPfile.Name = "tblImportAppend " Then
CurrentDb.TableDefs.Delete WayneIMPfile.Name
End If
Next
DoCmd.TransferDatabase acImport, "Microsoft Access", "Path to
ExternalDatabase.mdb", acTable, " tblOldExport ", " tblImportAppend "
DoCmd.SetWarnings False
DoCmd.OpenQuery " qryImportAppend "
DoCmd.SetWarnings True
CurrentDb.TableDefs.Delete "tblImportAppend"
End Sub

Notes on this code
1 Change the names to whatever you want. - I wouldn't have WayneIMPFile -
unless .... :)
2 The 1st section just looks for and deletes tblImportAppend if it's there
3 The next bit DoCmd.TransferDatabase is a standard way to bring in tables
to a DB (press F1 for more information)
4 The path to the MDB can be found by (another cheat).
Start - Run - Browse - Navigate to DB - Select open - Cut the path from the
run box and paste into code - Close run
5 Turn of warning
6 DoCmd.OpenQuery Runs the append query
7 Turn the warnings back on
8 Delete the table the code created (tblImportAppend)
9 End Sub - go and have a coffee

Note - if you look at the design of the Append Query it will look wrong -as
there is no table to base it on. Don't worry this is normal. The code will
create the table, run the query then delete the table again (I tend to do
this as it's just extra disk space).

Of course you can append the data to other tables and you don't need to
append all fields. If you play around with the code and the Append you will
get it to do want you need.

I use this method quite often and have the validation process in the append
query - is text formatted correctly, are numbers right, are postcodes
formated so the post office will acept them, etc, etc. But the most
important validation I use is not importing records that are already in the
table. You can use a time/date stamp (field) in the external table and in
the append simple put something like
[TimeDateField] in the criteria row.

Good luck

--
Wayne
Manchester, England.



thread said:
i would like to link the tables coming from the web below(extract it
by view code)
does anyone have an example of an option to link the information
direcly to access?
<HTML>
<HEAD><TITLE>Location Database Reports</TITLE></HEAD>
<BODY BGCOLOR=#FFFFFF>
<H1><CENTER>Location Database Reports</CENTER></H1>
<HR>
To run a Location Database report follow the instructions below and
then press the "Submit Form" button.
<FORM METHOD=POST ACTION="loc_display.asp">
<HR>
Select what type of report you want:<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=page CHECKED> <B>Detail
Report:</B> Display <INPUT TYPE="text" SIZE=2 NAME="pg_size"
VALUE=1>
matching locations per screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=all> <B>Summary Report:</B>
Display all matching locations on one screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv1> <B>Extract Report with
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv> <B>Extract Report without
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv2> <B>Extract Report in
Microsoft Excel Format:</B> Display location data in a spreadsheet
showing all columns.&nbsp &nbsp <A HREF="locationSchema.asp">Show
Location Data Schema</A><P>
<HR>
Fill in all of the fields you want to query by. You can use the "%"
character as a wildcard character.
<P><P>
<TABLE BORDER=0 WIDTH=100%>
<P>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER>
<B>Status</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<SELECT NAME=loc_status>
<OPTION VALUE>
<OPTION SELECTED VALUE=C >CURRENT
<OPTION VALUE=P >PENDING
<OPTION VALUE=D >DELETED
</SELECT>
</TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Location Code</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=10 NAME="loc_code"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Type</B></TD>
<TD><SELECT NAME="loc_type">
<OPTION VALUE>
<OPTION SELECTED VALUE=D>FACILITY &nbsp &nbsp &nbsp &nbsp &nbsp
<OPTION VALUE=H>HOME

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Name</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=35 NAME="loc_sitename"></TD>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Country</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER><SELECT NAME="loc_country">
<OPTION SELECTED>
<OPTION>ANGOLA
<OPTION>ARGENTINA
<OPTION>AUSTRALIA
<OPTION>AUSTRIA
<OPTION>BANGLADESH
<OPTION>BARBADOS
<OPTION>BELARUS
<OPTION>BELGIUM
<OPTION>BOLIVIA
<OPTION>BRAZIL
<OPTION>BULGARIA
<OPTION>CANADA
<OPTION>CHILE
<OPTION>CHINA
<OPTION>COLOMBIA
<OPTION>CONGO
<OPTION>COSTA RICA
<OPTION>CROATIA
<OPTION>CZECH REPUBLIC
<OPTION>DEMOCRATIC REP OF CONGO
<OPTION>DENMARK
<OPTION>DOMINICAN REPUBLIC
<OPTION>ECUADOR
<OPTION>EGYPT
<OPTION>FINLAND
<OPTION>FRANCE
<OPTION>GEORGIA
<OPTION>GERMANY
<OPTION>GHANA
<OPTION>GREECE
<OPTION>GUAM
<OPTION>GUATEMALA
<OPTION>HONG KONG
<OPTION>HUNGARY
<OPTION>INDIA
<OPTION>INDONESIA
<OPTION>IRAQ
<OPTION>IRELAND
<OPTION>ISRAEL
<OPTION>ITALY
<OPTION>JAPAN
<OPTION>JORDAN
<OPTION>KAZAKHSTAN
<OPTION>KUWAIT
<OPTION>LATVIA
<OPTION>LEBANON
<OPTION>LITHUANIA
<OPTION>MALAYSIA
<OPTION>MALDIVES
<OPTION>MEXICO
<OPTION>MOROCCO
<OPTION>NETHERLANDS
<OPTION>NEW ZEALAND
<OPTION>NIGERIA
<OPTION>NORWAY
<OPTION>OMAN
<OPTION>PAKISTAN
<OPTION>PANAMA
<OPTION>PERU
<OPTION>PHILIPPINES
<OPTION>POLAND
<OPTION>PORTUGAL
<OPTION>PUERTO RICO
<OPTION>QATAR
<OPTION>ROMANIA
<OPTION>RUSSIA
<OPTION>SAUDI ARABIA
<OPTION>SERBIA
<OPTION>SINGAPORE
<OPTION>SLOVAKIA
<OPTION>SLOVENIA
<OPTION>SOUTH AFRICA
<OPTION>SOUTH KOREA
<OPTION>SPAIN
<OPTION>SRI LANKA
<OPTION>SWEDEN
<OPTION>SWITZERLAND
<OPTION>TAIWAN
<OPTION>TANZANIA
<OPTION>THAILAND
<OPTION>TURKEY
<OPTION>UKRAINE
<OPTION>UNITED ARAB EMIRATES
<OPTION>UNITED KINGDOM
<OPTION>UNITED STATES
<OPTION>URUGUAY
<OPTION>UZBEKISTAN
<OPTION>VENEZUELA
<OPTION>VIETNAM
<OPTION>YEMEN
</SELECT>
</TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Complete Address</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address1"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>State/Province</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=25 NAME="loc_state"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address2"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>City</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_city"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address3"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Zip Code</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_zip"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address4"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Phone</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_phone"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address5"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Fax</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=20 NAME="loc_fax"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address6"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Time Zone</B></TD>
<TD ALIGN=LEFT

...

»- -

- -
 
W

Wayne-I-M

I'm sorry I don't understand your question - English is not my 1st language.
Can you put it another way.

--
Wayne
Manchester, England.



thread said:
On 15 , 14:53, Wayne-I-M <[email protected]>
wrote:
Hi Wayne,

the question is what should be done if the table is changing by the
link and it is only diffrent report how can i link dirrecly to the
runing report,the link i gave is the web extracting the reports but
the link its changing all the time
Hi

This is a copy of a post I made some time ago. It will bring data from an
external DB into an access DB.

_________________________________

This gets asked quite a bit so I thought I would give one method. (sorry if
the english is not too good)

To import data from a table in an external database into (append) to a table
in your internal database.

This is not the only way to do this - there are other methods - the "cheats"
I have given here you can either or not - I use them as I'm lazy and - in
this case - the end justifies the means (especially when the means are
deleted
after the end is accomplished?)

Names - In this I have used....

External Database - This is where the records are now
The records are in a table called tblOldExport

Internal Database - This is where I want them to be
tblInternalNewRecords - This the table in Internal Database where I want
the records go
-----------------------------------------
1 This is the 1st cheat - go to External Database and copy the table
containing the data you want to bring in.

2 Go to Internal Database and paste the table (structure only). Call it
tblImportAppend

3 Past the same table again (structure only) Call it tblInternalNewRecords

So you now have 2 empty copies of the table tblOldExport (but in your
Intenal Database) with new names.

4 Create a new query in your internal database (call it qryImportAppend).
Base this new query on tblImportAppend. Individually click each of the fields
so they all shown in the design grid.

5 Change the query to an Append Query. In the drop down list select
tblInternalNewRecords. If you have copied the tables correctly the fields in
the "Append To" row will fill in automatically. (You can change these update
to fields)

6 Create a new form in Internal Database.

7 Create a new button (call it cboImport)

8 Put this code on the OnClick event

Private Sub cboImport _Click()
Dim WayneIMPfile As TableDef
For Each WayneIMPfile In CurrentDb.TableDefs
If WayneIMPfile.Name = "tblImportAppend " Then
CurrentDb.TableDefs.Delete WayneIMPfile.Name
End If
Next
DoCmd.TransferDatabase acImport, "Microsoft Access", "Path to
ExternalDatabase.mdb", acTable, " tblOldExport ", " tblImportAppend "
DoCmd.SetWarnings False
DoCmd.OpenQuery " qryImportAppend "
DoCmd.SetWarnings True
CurrentDb.TableDefs.Delete "tblImportAppend"
End Sub

Notes on this code
1 Change the names to whatever you want. - I wouldn't have WayneIMPFile -
unless .... :)
2 The 1st section just looks for and deletes tblImportAppend if it's there
3 The next bit DoCmd.TransferDatabase is a standard way to bring in tables
to a DB (press F1 for more information)
4 The path to the MDB can be found by (another cheat).
Start - Run - Browse - Navigate to DB - Select open - Cut the path from the
run box and paste into code - Close run
5 Turn of warning
6 DoCmd.OpenQuery Runs the append query
7 Turn the warnings back on
8 Delete the table the code created (tblImportAppend)
9 End Sub - go and have a coffee

Note - if you look at the design of the Append Query it will look wrong - as
there is no table to base it on. Don't worry this is normal. The code will
create the table, run the query then delete the table again (I tend to do
this as it's just extra disk space).

Of course you can append the data to other tables and you don't need to
append all fields. If you play around with the code and the Append you will
get it to do want you need.

I use this method quite often and have the validation process in the append
query - is text formatted correctly, are numbers right, are postcodes
formated so the post office will acept them, etc, etc. But the most
important validation I use is not importing records that are already in the
table. You can use a time/date stamp (field) in the external table and in
the append simple put something like
[TimeDateField] in the criteria row.

Good luck

--
Wayne
Manchester, England.



thread said:
i would like to link the tables coming from the web below(extract it
by view code)
does anyone have an example of an option to link the information
direcly to access?
<HTML>
<HEAD><TITLE>Location Database Reports</TITLE></HEAD>
<BODY BGCOLOR=#FFFFFF>
<H1><CENTER>Location Database Reports</CENTER></H1>
<HR>
To run a Location Database report follow the instructions below and
then press the "Submit Form" button.
<FORM METHOD=POST ACTION="loc_display.asp">
<HR>
Select what type of report you want:<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=page CHECKED> <B>Detail
Report:</B> Display <INPUT TYPE="text" SIZE=2 NAME="pg_size"
VALUE=1>
matching locations per screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=all> <B>Summary Report:</B>
Display all matching locations on one screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv1> <B>Extract Report with
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv> <B>Extract Report without
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv2> <B>Extract Report in
Microsoft Excel Format:</B> Display location data in a spreadsheet
showing all columns.&nbsp &nbsp <A HREF="locationSchema.asp">Show
Location Data Schema</A><P>
<HR>
Fill in all of the fields you want to query by. You can use the "%"
character as a wildcard character.
<P><P>
<TABLE BORDER=0 WIDTH=100%>
<P>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER>
<B>Status</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<SELECT NAME=loc_status>
<OPTION VALUE>
<OPTION SELECTED VALUE=C >CURRENT
<OPTION VALUE=P >PENDING
<OPTION VALUE=D >DELETED
</SELECT>
</TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Location Code</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=10 NAME="loc_code"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Type</B></TD>
<TD><SELECT NAME="loc_type">
<OPTION VALUE>
<OPTION SELECTED VALUE=D>FACILITY &nbsp &nbsp &nbsp &nbsp &nbsp
<OPTION VALUE=H>HOME

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Name</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=35 NAME="loc_sitename"></TD>

<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Country</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER><SELECT NAME="loc_country">
<OPTION SELECTED>
<OPTION>ANGOLA
<OPTION>ARGENTINA
<OPTION>AUSTRALIA
<OPTION>AUSTRIA
<OPTION>BANGLADESH
<OPTION>BARBADOS
<OPTION>BELARUS
<OPTION>BELGIUM
<OPTION>BOLIVIA
<OPTION>BRAZIL
<OPTION>BULGARIA
<OPTION>CANADA
<OPTION>CHILE
<OPTION>CHINA
<OPTION>COLOMBIA
<OPTION>CONGO
<OPTION>COSTA RICA
<OPTION>CROATIA
<OPTION>CZECH REPUBLIC
<OPTION>DEMOCRATIC REP OF CONGO
<OPTION>DENMARK
<OPTION>DOMINICAN REPUBLIC
<OPTION>ECUADOR
<OPTION>EGYPT
<OPTION>FINLAND
<OPTION>FRANCE
<OPTION>GEORGIA
<OPTION>GERMANY
<OPTION>GHANA
<OPTION>GREECE
<OPTION>GUAM
<OPTION>GUATEMALA
<OPTION>HONG KONG
<OPTION>HUNGARY
<OPTION>INDIA
<OPTION>INDONESIA
<OPTION>IRAQ
<OPTION>IRELAND
<OPTION>ISRAEL
<OPTION>ITALY
<OPTION>JAPAN
<OPTION>JORDAN
<OPTION>KAZAKHSTAN
<OPTION>KUWAIT
<OPTION>LATVIA
<OPTION>LEBANON
<OPTION>LITHUANIA
<OPTION>MALAYSIA
<OPTION>MALDIVES
<OPTION>MEXICO
<OPTION>MOROCCO
<OPTION>NETHERLANDS
<OPTION>NEW ZEALAND
<OPTION>NIGERIA
<OPTION>NORWAY
<OPTION>OMAN
<OPTION>PAKISTAN
<OPTION>PANAMA
<OPTION>PERU
<OPTION>PHILIPPINES
<OPTION>POLAND
<OPTION>PORTUGAL
<OPTION>PUERTO RICO
<OPTION>QATAR
<OPTION>ROMANIA
<OPTION>RUSSIA
<OPTION>SAUDI ARABIA
<OPTION>SERBIA
<OPTION>SINGAPORE
<OPTION>SLOVAKIA
<OPTION>SLOVENIA
<OPTION>SOUTH AFRICA
<OPTION>SOUTH KOREA
<OPTION>SPAIN
<OPTION>SRI LANKA
<OPTION>SWEDEN
<OPTION>SWITZERLAND
<OPTION>TAIWAN
<OPTION>TANZANIA
<OPTION>THAILAND
<OPTION>TURKEY
<OPTION>UKRAINE
<OPTION>UNITED ARAB EMIRATES
<OPTION>UNITED KINGDOM
<OPTION>UNITED STATES
<OPTION>URUGUAY
<OPTION>UZBEKISTAN
<OPTION>VENEZUELA
<OPTION>VIETNAM
<OPTION>YEMEN
</SELECT>
</TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Complete Address</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address1"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>State/Province</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=25 NAME="loc_state"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
 
T

thread

I'm sorry I don't understand your question - English is not my 1st language.
Can you put it another way.

--
Wayne
Manchester, England.



thread said:
On 15 , 14:53, Wayne-I-M <[email protected]>
wrote:
Hi Wayne,
the question is what should be done if the table is changing by the
link and it is only diffrent report how can i link dirrecly to the
runing report,the link i gave is the web extracting the reports but
the link its changing all the time
Hi
This is a copy of a post I made some time ago. It will bring data from an
external DB into an access DB.
_________________________________
This gets asked quite a bit so I thought I would give one method. (sorry if
the english is not too good)
To import data from a table in an external database into (append) to a table
in your internal database.
This is not the only way to do this - there are other methods - the "cheats"
I have given here you can either or not - I use them as I'm lazy and - in
this case - the end justifies the means (especially when the means are
deleted
after the end is accomplished?)
Names - In this I have used....
External Database - This is where the records are now
The records are in a table called tblOldExport
Internal Database - This is where I want them to be
tblInternalNewRecords - This the table in Internal Database where Iwant
the records go
-----------------------------------------
1 This is the 1st cheat - go to External Database and copy the table
containing the data you want to bring in.
2 Go to Internal Database and paste the table (structure only). Call it
tblImportAppend
3 Past the same table again (structure only) Call it tblInternalNewRecords
So you now have 2 empty copies of the table tblOldExport (but in your
Intenal Database) with new names.
4 Create a new query in your internal database (call it qryImportAppend).
Base this new query on tblImportAppend. Individually click each of the fields
so they all shown in the design grid.
5 Change the query to an Append Query. In the drop down list select
tblInternalNewRecords. If you have copied the tables correctly the fields in
the "Append To" row will fill in automatically. (You can change theseupdate
to fields)
6 Create a new form in Internal Database.
7 Create a new button (call it cboImport)
8 Put this code on the OnClick event
Private Sub cboImport _Click()
Dim WayneIMPfile As TableDef
For Each WayneIMPfile In CurrentDb.TableDefs
If WayneIMPfile.Name = "tblImportAppend " Then
CurrentDb.TableDefs.Delete WayneIMPfile.Name
End If
Next
DoCmd.TransferDatabase acImport, "Microsoft Access", "Path to
ExternalDatabase.mdb", acTable, " tblOldExport ", " tblImportAppend "
DoCmd.SetWarnings False
DoCmd.OpenQuery " qryImportAppend "
DoCmd.SetWarnings True
CurrentDb.TableDefs.Delete "tblImportAppend"
End Sub
Notes on this code
1 Change the names to whatever you want. - I wouldn't have WayneIMPFile -
unless .... :)
2 The 1st section just looks for and deletes tblImportAppend if it's there
3 The next bit DoCmd.TransferDatabase is a standard way to bring intables
to a DB (press F1 for more information)
4 The path to the MDB can be found by (another cheat).
Start - Run - Browse - Navigate to DB - Select open - Cut the path from the
run box and paste into code - Close run
5 Turn of warning
6 DoCmd.OpenQuery Runs the append query
7 Turn the warnings back on
8 Delete the table the code created (tblImportAppend)
9 End Sub - go and have a coffee
Note - if you look at the design of the Append Query it will look wrong - as
there is no table to base it on. Don't worry this is normal. The code will
create the table, run the query then delete the table again (I tend to do
this as it's just extra disk space).
Of course you can append the data to other tables and you don't need to
append all fields. If you play around with the code and the Append you will
get it to do want you need.
I use this method quite often and have the validation process in the append
query - is text formatted correctly, are numbers right, are postcodes
formated so the post office will acept them, etc, etc. But the most
important validation I use is not importing records that are already in the
table. You can use a time/date stamp (field) in the external table and in
the append simple put something like
[TimeDateField] in the criteria row.
Good luck
--
Wayne
Manchester, England.
:
hi all,
i would like to link the tables coming from the web below(extract it
by view code)
does anyone have an example of an option to link the information
direcly to access?
<HTML>
<HEAD><TITLE>Location Database Reports</TITLE></HEAD>
<BODY BGCOLOR=#FFFFFF>
<H1><CENTER>Location Database Reports</CENTER></H1>
<HR>
To run a Location Database report follow the instructions below and
then press the "Submit Form" button.
<FORM METHOD=POST ACTION="loc_display.asp">
<HR>
Select what type of report you want:<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=page CHECKED> <B>Detail
Report:</B> Display <INPUT TYPE="text" SIZE=2 NAME="pg_size"
VALUE=1>
matching locations per screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=all> <B>Summary Report:</B>
Display all matching locations on one screen.<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv1> <B>Extract Report with
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv> <B>Extract Report without
Location Code:</B> Display a pipe separated report (used to import
data into other applications).<P>
<INPUT TYPE=RADIO NAME=screentype VALUE=csv2> <B>Extract Report in
Microsoft Excel Format:</B> Display location data in a spreadsheet
showing all columns.&nbsp &nbsp <A HREF="locationSchema.asp">Show
Location Data Schema</A><P>
<HR>
Fill in all of the fields you want to query by. You can use the "%"
character as a wildcard character.
<P><P>
<TABLE BORDER=0 WIDTH=100%>
<P>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER>
<B>Status</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<SELECT NAME=loc_status>
<OPTION VALUE>
<OPTION SELECTED VALUE=C >CURRENT
<OPTION VALUE=P >PENDING
<OPTION VALUE=D >DELETED
</SELECT>
</TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Location Code</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=10 NAME="loc_code"></TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Type</B></TD>
<TD><SELECT NAME="loc_type">
<OPTION VALUE>
<OPTION SELECTED VALUE=D>FACILITY &nbsp &nbsp &nbsp &nbsp &nbsp
<OPTION VALUE=H>HOME
</SELECT></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Site Name</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=35 NAME="loc_sitename"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Country</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER><SELECT NAME="loc_country">
<OPTION SELECTED>
<OPTION>ANGOLA
<OPTION>ARGENTINA
<OPTION>AUSTRALIA
<OPTION>AUSTRIA
<OPTION>BANGLADESH
<OPTION>BARBADOS
<OPTION>BELARUS
<OPTION>BELGIUM
<OPTION>BOLIVIA
<OPTION>BRAZIL
<OPTION>BULGARIA
<OPTION>CANADA
<OPTION>CHILE
<OPTION>CHINA
<OPTION>COLOMBIA
<OPTION>CONGO
<OPTION>COSTA RICA
<OPTION>CROATIA
<OPTION>CZECH REPUBLIC
<OPTION>DEMOCRATIC REP OF CONGO
<OPTION>DENMARK
<OPTION>DOMINICAN REPUBLIC
<OPTION>ECUADOR
<OPTION>EGYPT
<OPTION>FINLAND
<OPTION>FRANCE
<OPTION>GEORGIA
<OPTION>GERMANY
<OPTION>GHANA
<OPTION>GREECE
<OPTION>GUAM
<OPTION>GUATEMALA
<OPTION>HONG KONG
<OPTION>HUNGARY
<OPTION>INDIA
<OPTION>INDONESIA
<OPTION>IRAQ
<OPTION>IRELAND
<OPTION>ISRAEL
<OPTION>ITALY
<OPTION>JAPAN
<OPTION>JORDAN
<OPTION>KAZAKHSTAN
<OPTION>KUWAIT
<OPTION>LATVIA
<OPTION>LEBANON
<OPTION>LITHUANIA
<OPTION>MALAYSIA
<OPTION>MALDIVES
<OPTION>MEXICO
<OPTION>MOROCCO
<OPTION>NETHERLANDS
<OPTION>NEW ZEALAND
<OPTION>NIGERIA
<OPTION>NORWAY
<OPTION>OMAN
<OPTION>PAKISTAN
<OPTION>PANAMA
<OPTION>PERU
<OPTION>PHILIPPINES
<OPTION>POLAND
<OPTION>PORTUGAL
<OPTION>PUERTO RICO
<OPTION>QATAR
<OPTION>ROMANIA
<OPTION>RUSSIA
<OPTION>SAUDI ARABIA
<OPTION>SERBIA
<OPTION>SINGAPORE
<OPTION>SLOVAKIA
<OPTION>SLOVENIA
<OPTION>SOUTH AFRICA
<OPTION>SOUTH KOREA
<OPTION>SPAIN
<OPTION>SRI LANKA
<OPTION>SWEDEN
<OPTION>SWITZERLAND
<OPTION>TAIWAN
<OPTION>TANZANIA
<OPTION>THAILAND
<OPTION>TURKEY
<OPTION>UKRAINE
<OPTION>UNITED ARAB EMIRATES
<OPTION>UNITED KINGDOM
<OPTION>UNITED STATES
<OPTION>URUGUAY
<OPTION>UZBEKISTAN
<OPTION>VENEZUELA
<OPTION>VIETNAM
<OPTION>YEMEN
</SELECT>
</TD>
<TD ALIGN=RIGHT VALIGN=CENTER><B>Complete Address</B></TD>
<TD ALIGN=LEFT VALIGN=CENTER>
<INPUT TYPE="text" SIZE=30 NAME="loc_address1"></TD>
</TR>
<TR>
<TD ALIGN=RIGHT

...

»- -

- -

the code source i put in here is not the table link but the page that
from there the table or report can be extraced
i want to extract the report/table directly from the web
becaouse you have a choose list that you are choosing to extract
report/table and then its extracting,but the report/table is all the
time changing the link
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top