Vikas-
The easiest way is to use a data link from Excel and then import or link the
data into Access. In Excel, click the Data tab (if you're using 2007 or later)
and then click From Web in Get External Data. In the New Web Query window,
navigate to the page you want, click on the yellow arrow that points to the data
you want to import, then click Import. If you got what you want, you can save
the connection and give it a name by clicking Properties in the Connection
group. That creates a .iqy file on your computer. If there are parameters
passed to the web page, you can edit the .iqy file with Notepad to insert
parameter references, then go back to Excel and define cells to pick up the
parameter values in Data / Connections / Connections / Properties / Definitions
/ Parameters.
It's also possible to automate this process from Access, but let's see if you
can get this far first.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of VIkas Kumar
Sent: Tuesday, July 05, 2011 10:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] MS SQL :- Export Data From Website
Hey Masters,
I want help for MS SQL
my question in : - how to export data from website and automatically create
tale............
Please help me .............
--
Warm Regards,
Vikas Chauhan
"We can't Spell S_ccess without U"
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar