使用Excel宏进行代码传输 [英] Code transfer using excel macros

问题描述

我需要通过单击按钮使用oledb连接将数据从excel工作表传输到sql服务器.
单击按钮时-
连接应与sql server形成
并且excel工作表中的数据应存储在数据库的登台表中.

[edit]紧急情况已删除:这可能对您来说很紧急，但对我们而言并非如此.强调紧迫性只会使某些人烦恼，并且可能会使响应速度变慢-OriginalGriff [/edit]

Hi,
I need to transfer my data from an excel sheet to sql server using oledb connection on click of a button.
On click of button-
connection should be formed with sql server
and data in excel sheet should get stored in a staging table in database.

[edit]Urgency removed: It may be urgent to you, but it isn''t to us. Stressing the urgency just annoys some people and can slow a response - OriginalGriff[/edit]

推荐答案

Google是您的朋友:快速检查一下从从您的问题中粘贴的将Excel工作表转换为sql服务器"中，发现了2,000,000次匹配，其首页看起来可以多次保存该解决方案.

将来，请尝试进行一些基础研究-比问问题要快得多.

Google is your friend: A quick check with "transfer my data from an excel sheet to sql server" pasted from your question found over 2,000,000 hits, the first page of which looks to hold the solution many times.

In future, please try to do some basic research - it is a lot quicker than asking a question.

这篇关于使用Excel宏进行代码传输的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！