从Access Excel中读取数据 [英] reading data in to Access From Excel

问题描述

大家好，

我对VB很新。我想弄清楚如何编写一个

脚本，以便我可以从中读取数据可以访问excel表格。


你能帮帮我吗？


欢呼，

nuti

解决方案

最简单的方法是通过以下方式连接到Excel数据：

文件|获取外部

您可以链接，如果数据在Excel中定期更新，并且您想要

最新数据，或者如果您想要在Access中操作数据而不导入

影响电子表格。


-

Allen Browne - 微软MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" nuti" < NU ******** @ yahoo.co.in>在消息中写道

news：11 ********************** @ f14g2000cwb.googlegr oups.com ...

大家好，
我对VB很新。我想弄清楚如何编写一个
脚本，这样我就可以将excel表中的数据读取到Access。 />
你们可以帮帮我吗？

谢谢Allen ......但是我希望通过在

excel表中编写一个宏来实现自动化。

在运行宏时，它应该将数据写入以进行访问。
$ b $你可以寄给我代码吗？


欢呼，

Nuti

< blockquote>从Access中，你可以使用TransfrerSpreadsheet动作从Excel中获取东西




如果你想知道如何在Excel中做到这一点，你可能会在其中一个Excel

组中询问。


-

Allen Browne - Microsoft MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" nuti" < NU ******** @ yahoo.co.in>在消息中写道

news：11 ********************** @ o13g2000cwo.googlegr oups.com ...

感谢Allen ....但我想通过在
excel表中编写一个宏来实现自动化。
在运行宏时，它应该将数据写入访问。
你能给我发送代码吗？

Hi all,
I am fairly new to VB.I am trying to figure out as how to write a
script so that i can read the data from an excel sheet to Access.

can u guys please help me out?

cheers,
nuti

解决方案

The simplest way is to connect to the Excel data via:
File | Get External
You can link if the data is regularly updated in Excel and you want the
latest data, or import if you want to operate on the data in Access without
affecting the spreadsheet.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nuti" <nu********@yahoo.co.in> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi all,
I am fairly new to VB.I am trying to figure out as how to write a
script so that i can read the data from an excel sheet to Access.

can u guys please help me out?

Hi,
Thanks Allen ....But i want to automate it by writing a macro in the
excel sheet.
On running the macro it should write the data in to access.
can you send me the code for it?

cheers,
Nuti

From in Access, you would use the TransfrerSpreadsheet action to get stuff
from Excel

If you want do know how to do it in Excel, you might ask in one of the Excel
groups.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nuti" <nu********@yahoo.co.in> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hi,
Thanks Allen ....But i want to automate it by writing a macro in the
excel sheet.
On running the macro it should write the data in to access.
can you send me the code for it?

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