从excel 2007工作表将数据导出到sql server

问题描述:

我需要从excel 2007工作表中导出一些数据 进入sql server 2005表。我希望用户在工作表上填写一些数据,然后单击按钮以运行要导出的VBA宏。根本不知道怎么做到这一点

I need to export some data from an excel 2007 sheet  into a sql server 2005 table. I would like for the user to fill in some data on the sheet and click a button to run a VBA Macro to export. Not at all sure how to accomplish this

你能不能告诉我们怎么样?数据看起来像?

Can You have the kindness to tell us how the data look like?