如何导入 access 数据库

relivell 2011-03-17 09:14:25
检索文献之后下载的数据,想把每一条变成access表格的一条记录,每一项内容成为字段,怎么处理呢?望好心人帮忙解决!非常谢谢!以下是原始数据,列了2条,事实上有上百条,甚至上千条,我现在要对这些数据进行分析,这样从文本文档看很累,想做成数据库形式,这样方便很多,也节省时间和精力,有什么建议的方法吗?
1. Phytochem Anal. 2011 Jan 24. doi: 10.1002/pca.1274. [Epub ahead of print]

Isolation of four high-purity dammarane saponins from extract of Panax
notoginseng by centrifugal partition chromatography coupled with evaporative
light scattering detection in one operation.

Wang J, Liu CM, Li L, Bai HL.

Department of Chemistry, Changchun Normal University, Changchun 130032, China.

Introduction - Centrifugal partition chromatography (CPC), as a continuous
liquid-liquid partition chromatography with no solid support matrix, combined
with evaporative light scattering detection (ELSD) was employed for systematic
separation and purification of weak-chromophoric saponins from a highly valued
and important traditional Chinese herbal medicine, Panax notoginseng. Objective -
To separate and isolate high-purity saponins from extract of Panax notoginseng
using CPC-ELSD with a simple and low toxicity solvent system. Methodology -
Samples were preparaed by extracting the root material with acetone, treated with
n-butanol and then freeze-dried. CPC-ELSD was applied in the separation and
detection of notoginsenoside and ginsenosides from extract of Panax notoginseng
using a solvent system composed of ethyl acetate-n-butanol-water (1:1:2, v/v/v).
The saponins were analysed and identified by their retention time with
high-performance liquid chromatography (HPLC) coupled with ELSD, as well as
electrospray ionisation tandem mass spectrometry (ESI-MS(n) ) in the negative and
positive ion modes with the authentic standards. Results - A total of 9.6 mg of
notoginsenoside R(1) , 67.8 mg of ginsenoside Rg(1) , 2.3 mg of Re and 286.5 mg
of Rb(1) were purified from 487.2 mg of n-butanol extract of P. notoginseng. The
purities of obtained saponins in a single run were assessed to be over 98% by
HPLC-ELSD. Conclusion - CPC-ELSD was proved to be a very fast and efficient tool
for separation of high-purity dammarane saponins. Copyright © 2011 John Wiley &
Sons, Ltd.


PMID: 21259375 [PubMed - as supplied by publisher]


2. Chin Med. 2011 Jan 24;6(1):5.

Saponin accumulation in the seedling root of Panax notoginseng.

Wang D, Zhu H, Chen K, Xu M, Zhang Y, Yang C.

State Key Laboratory of Phytochemistry and Plant Resources of West China, Kunming
Institute of Botany, Chinese Academy of Sciences, Kunming 650204, PR China.
zhangyj@mail.kib.ac.cn.

ABSTRACT:BACKGROUND: Panax notoginseng is an important Chinese medicinal plant.
Dammarene-type triterpenoid saponins are main pharmacologically effective
compounds in P. notoginseng. This study aims to investigate the formation and
accumulation of saponins in P. notoginseng roots during germination and juvenile
stage.
METHODS: P. notoginseng seeds were collected and stored in wet sand. After
germination, the seedlings were transplanted into a soil nursery bed and
cultivated for one year. During this period, samples were collected every month
and the concentrations of ginsengnosides Rg1, Re, Rb1, Rd and notoginsengnoside
R1 were determined by HPLC.
RESULTS: There was little saponin in the P. notoginseng seed. The chemical
composition of seed was different from that of root. After germination, Rb1, Rg1,
Re, Rd and R1 appeared successively in the seedling root. And in the
five-month-old root, all these five main saponins came into existence. The
accumulation of saponins in P. notoginseng root was affected by seasons.
CONCLUSION: The accumulation of saponins showed a time-dependent increase after
germination of P. notoginseng.


PMCID: PMC3033864
PMID: 21255468 [PubMed - in process]
...全文
245 点赞 收藏 17
写回复
17 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
relivell 2011-04-06
泰山,你好,能不能帮帮忙呀!

[Quote=引用 15 楼 dbcontrols 的回复:]
隔行如隔山
就是学VC的要想短时间学会VB也难
何况你编程没基础
可以出钱包出去



引用 14 楼 relivell 的回复:
几乎没有一点基础,我是学医药的,现在需要做这些工作,一下子又学不会这些东西,所以来这里求解,很郁闷呢
[/Quote]
回复
relivell 2011-03-28
呵呵,我又不是领导,哪能说包出去就包出去。学习任何东西都是循序渐进的过程,我学习VB也一下子解决不了这些问题,尽管很简单。现在的问题是怎么解决这个问题,怎么节省时间,我现在正在也即将面临大量的这样的数据处理。
回复
dbcontrols 2011-03-25
隔行如隔山
就是学VC的要想短时间学会VB也难
何况你编程没基础
可以出钱包出去


[Quote=引用 14 楼 relivell 的回复:]
几乎没有一点基础,我是学医药的,现在需要做这些工作,一下子又学不会这些东西,所以来这里求解,很郁闷呢
[/Quote]
回复
relivell 2011-03-25
几乎没有一点基础,我是学医药的,现在需要做这些工作,一下子又学不会这些东西,所以来这里求解,很郁闷呢
回复
jjhhgg1111 2011-03-23
lz不会是一点基础都没有吧
回复
relivell 2011-03-23
可能很简单,可对于我这个新手来说,技术是问题,我不知道如何处理,所以才会发帖提问。
我不是用软件扒拉别人网站上的东西,信息检索本来需要下载文献的,数据库或者免费的数据库本来就是供人使用的,我只是合理利用资源。这些资源于我有用,所以我需要后续处理。
既然泰山认为很简单,简单的事情不需要太多时间,那么我希望你能替我解答了。
当然,谁替我解答我都很高兴,很感激!
回复
relivell 2011-03-23
这些数据时我从免费的数据库上检索文献的结果,检索文献一般都会下载数据的。我有很多条类似的数据,我知道怎么区分这些数据,现在的问题是我不知道怎么用软件区分这些数据,所以才来求解,望解答!
回复
king06 2011-03-18
拿第2条来说,建议设置6个字段来保存
1) Chin Med. 2011 Jan 24;6(1):5.
2) Saponin accumulation in the seedling root of Panax notoginseng.
3) Wang D, Zhu H, Chen K, Xu M, Zhang Y, Yang C.
4) 中间的说明性文字为一个字段(这里文字较多,可将数据库字段类型定义为备注型)
5) PMCID: PMC3033864
6)PMID: 21255468 [PubMed - in process]


回复
relivell 2011-03-18
之前只发过两个帖子,这是第三帖,刚刚把以前的帖子结帖了,凡能得到教益的把分数分配给他们,同时也谢谢帮助!
也谢谢泰山的提醒,初来乍到,请多包涵,也请多关照!
回复
dbcontrols 2011-03-18
这是个人工智能的问题,你的眼睛是怎么区分的软件就怎么区分
关键是找到标志,比如里面的1.和2.
再就是找“Introduction -”等这样的词
不过不建议用软件去扒拉别人网站上的东西
如果确实有这些数据,处理起来不是很麻烦
用到很多基本的函数,如instr,mid等等
可以看看MSDN
技术不是问题,问题是什么区分、识别

[Quote=引用 9 楼 relivell 的回复:]
谢谢king06,可是我想知道这个过程怎么操作,这个txt文本文件的每一条记录怎样变成acsess的一条记录,怎么变成6个字段,具体过程怎么处理呢?
[/Quote]
回复
relivell 2011-03-18
谢谢king06,可是我想知道这个过程怎么操作,这个txt文本文件的每一条记录怎样变成acsess的一条记录,怎么变成6个字段,具体过程怎么处理呢?
回复
dbcontrols 2011-03-17
1.先学会结贴,否则没人搭理你,这里的分尽管没什么用,至少是尊重别人的劳动
2.主题帖就是一套程序,这个可能需要好长时间能做出来,时间是生命的组成单位,要尊重别人的生命和劳动,所以这个需要花钱。
回复
Flowing_Dream 2011-03-17
[Quote=引用 4 楼 dbcontrols 的回复:]
"不如"是笔误,应该是“比如”
[/Quote]
+1
我也是新人,在坛子里真的受到很大启发,很多时候的确也会得不到自己的想要的答案,但是回头想想就会发现是自己的问题太泛了,或者是没有说清楚。
回复
dbcontrols 2011-03-17
"不如"是笔误,应该是“比如”
回复
dbcontrols 2011-03-17
古人有一字之师之说
别人的回答有可能不是你想要的
但造成的原因是多方面的,不如问题本身提供的信息不足等等
但至少别人为了帮助你思考过,花费了时间和精力
哪怕有一点启发也好

[Quote=引用 2 楼 relivell 的回复:]
我刚来到此论坛,不太懂规矩,谢谢泰山的提醒!
可是我之前的问题都没得到我想要的答案,都没有最终解决问题,我不知道如何结帖,也不知道把分给谁,请问有何建议?
[/Quote]
回复
relivell 2011-03-17
我刚来到此论坛,不太懂规矩,谢谢泰山的提醒!
可是我之前的问题都没得到我想要的答案,都没有最终解决问题,我不知道如何结帖,也不知道把分给谁,请问有何建议?
回复
相关推荐
发帖

1188

社区成员

VB 数据库(包含打印,安装,报表)
申请成为版主
帖子事件
创建了帖子
2011-03-17 09:14
社区公告
暂无公告