从HTML表中获取数据到Access数据库中 [英] get data from an HTML table into an Access database

问题描述

如何从HTML表格(例如，从Market data S& P 500)动态填充数据库?

How I can fill a database dynamically from a HTML table (e.g., from Market data S&P 500)?

我有一个 Yahoo!的帐户.财务.在该帐户中，我可以查看HTML格式的财务数据.

I have an account with Yahoo! Financial. In the account I can view financial data in HTML.

我需要一个简单的工具来填充HTML表中的数据库(访问).在哪里可以找到这样的工具?

I need a simple tool to fill a data base (Access), from an HTML table. Where can I find a tool like that ?

推荐答案

您可以将Yahoo历史数据中的CSV格式导出为CSV，并直接将Access中的csv文件链接为MS Access表. http://office.microsoft.com/zh-CN/access-help/import-or-link-to-data-in-a-text-file-HA001232227.aspx

You can export as CSV from Yahoo historical data and link that csv file in Access as a MS Access Table directly. http://office.microsoft.com/en-ca/access-help/import-or-link-to-data-in-a-text-file-HA001232227.aspx

如果您想处理html页面源代码，那么此链接可能会有所帮助.

If you want to deal with the html page source then this link may help.

http://www.access-programmers.co.uk/forums/showthread.php?p = 1145646

这篇关于从HTML表中获取数据到Access数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！