excel访问文件名 [英] excel to access filename

问题描述

如何从excel导入的文件名访问并使文本框显示文件名？

我现在有一个文本框我只是不知道如何获取它显示。

how do you take the filename that you imported from excel to access and make a textbox to display the file name?
I have a textbox for it right now i just dont know how to get it show up.

推荐答案

你在这里问的是什么？我不知道如何帮助你这个问题还不清楚。考虑制作你想要的东西更清楚。请记住，我们只知道你告诉我们的内容，而且你告诉我们你的问题所带来的情况很少。

What are you asking actually here? It''s so unclear a question that I don''t know how to help you. Consider making what you want clearer. Remember that we only know what you tell us, and you''ve told us very little about the situation your question comes from.

好的。我在访问中有一个名为spr filename的字段。当我要将文件从excel导入到访问时，我想让excel文件的名称显示在我访问的表单上。

okay. i have a field called spr filename in access. when i am going to import the file from excel to access, i want to make the name of the excel file show up on my form in access.

在某些表中有一个字段一些名为[spr filename]的数据库。当你执行一个包含导入的进程时，你希望在某个表单上显示它。


现在，你不得不原谅我在这里有点含糊不清几乎没有任何信息可以使用，但我可以建议一个约束形式。表单可以绑定到其中包含字段的表中，并且TextBox控件可以绑定到字段本身。该表单允许您（操作员）浏览表中的记录，并且可能还有一个CommandButton控件，允许您选择用于运行导入的记录。


这听起来像你要问的那样吗？

You have a field in some tables in some database called [spr filename]. You want this to be shown on some form when you''re executing some process that includes an import.

Now, you''ll have to excuse me being a little vague here as there is almost no information to work with, but may I suggest a bound form. The form can be bound to whichever table has the field in it and a TextBox control can be bound to the field itself. The form would allow you (The operator) to navigate through the records in the table and might also have a CommandButton control on that allows you to select which record to use to run the import.

Does this sound like what you''re asking about?

这篇关于excel访问文件名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！