|
查看: 868|回复: 5
|
关于retrieve data from excel 然后 insert 在 access table
[复制链接]
|
|
|
|
我想只道如果我想insert data that I retrieve from excel file to a table in Access 是 如何 做的。我能retrieva data from excel and display in a asp page but all tht data dun have a value so i cant store it in database. |
|
|
|
|
|
|
|
|
|
|
|
发表于 10-11-2005 12:04 PM
|
显示全部楼层
1. 写 code - VBA, VB6, .Net
2. Access 有自动从 Excel 输入进 table 的功能. |
|
|
|
|
|
|
|
|
|
|
|
楼主 |
发表于 10-11-2005 02:06 PM
|
显示全部楼层
but i need it to run online base so do u have any reference about it????
HELP PLS |
|
|
|
|
|
|
|
|
|
|
|
发表于 10-11-2005 05:09 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
楼主 |
发表于 10-11-2005 10:59 PM
|
显示全部楼层
|
But if we get data from excel it dun have a variable to represent the values for us to insert to the data wog... |
|
|
|
|
|
|
|
|
|
|
|
发表于 11-11-2005 09:30 AM
|
显示全部楼层
原帖由 cytin 于 10-11-2005 10:59 PM 发表
But if we get data from excel it dun have a variable to represent the values for us to insert to the data wog...
你有看以上的连接吗?
以上提供的连接已经足以完成你的要求, 应该先去好好明白背后的原理.  |
|
|
|
|
|
|
|
|
|
| |
 本周最热论坛帖子
|
变色卡
千斤顶
2604 
63
