将数据从Excel工作表逐行导入到Access中 [英] Import data from excel sheet into Access line by line

问题描述

我想从excel导入数据以逐行访问表.
例如，用户单击访问表单中的按钮并插入行，
如果行不完整或与数据类型不匹配，则显示报告..
有样品吗?
现在该表格位于Access女士中.

I want to import the data from excel to access table line by line.
for example user click on a button in access form and it insert rows,
if rows was incomplete or mismatch with data type shows a report..
any sample?
now the form is in Ms Access

推荐答案

看看这个: ^ ]

最好的问候
Espen Harlinn

Have a look at this: Converting an Excel Spreadsheet to an Access 2007 Database[^]

Best regards
Espen Harlinn

尝试
http://www.exceltip.com/st/Export_data_from_Excel_to_Access_%28DAO%29_using_VBA_in_Microsoft_Excel/426.html /a> [^ ]

视频-此处 [

Try
http://www.exceltip.com/st/Export_data_from_Excel_to_Access_%28DAO%29_using_VBA_in_Microsoft_Excel/426.html[^]

Video - here[^].

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