导出excel以使用数据网格进行访问 [英] Exporting excel to access using a datagrid

问题描述

请问我正在做一个项目，它将数据从excel表读取到datagrid，并将数据从datagrid保存到将在运行时创建的访问数据库。已经完成了对datagrid的导入，即使这样，excel文件也需要在数据网格可以从中读取之前按字面打开。但至于在运行时创建的访问数据库的保存，我无法为它做任何事情。对于那一方，来自datagrid的数据将逐行或逐列读取到包括数据网格标题的数据库。请帮我。我的项目主管需要在星期一或下周进行工作原型。谢谢大家的帮助。

你可以给我发消息或给我发电子邮件以获取源代码..再次感谢你...

解决方案

< blockquote>请看一下类似的问题：

如何使用vb.net将Excel数据导入到Windows应用程序中的MS访问数据库 [ ^ ]

导入Excel工作表以使用vb.net访问数据库 [ ^ ]

Please I am doing a project that reads data from an excel sheet to a datagrid and the saves the data from the datagrid to an access database that will be created at runtime. The import to the datagrid has been done and even with that, the excel file needs to be opened literally before the datagrid can read from it. But as for the saving to the access database created at runtime, I have not been able to make any thing for it. For that side, the data from the datagrid is to be read row by row or column by column to the database including the datagrid headings. Please help me. My project supervisor needs a working prototype by monday or by next week. Thank you all for your help.
You can PM me or email me for the source code.. Thank you once again...

解决方案

Please, have a look at similar questions:
How to import the excel data to MS access database in windows application using vb.net[^]
Import Excel sheet to access database using vb.net[^]

这篇关于导出excel以使用数据网格进行访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！