Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I was wondering if it is possible to import data into a SQL Server 2000 table from a command button in excel. Basically I need to send users (over 50) an excel spreadsheet for them to fill out, once complete I then wanted them to press a command button and the data be sent autamatically to a SQL Server table. The data they fill out is: Client_ID, Business Group and Appointment Date, this will be sent to 50 people and I dont really want them to be emailing it me back for me to insert into a table in sql server. The table is already set up and has 3 fields, Client_ID, BusGroup and AppDate. Any help would be greatly appreciated. R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
How to import data from SQL Server | Excel Discussion (Misc queries) | |||
Data Upload from Excel to SQL Server | Links and Linking in Excel | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) |