import data into a SQL Server 200 table from a command button

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

Hi,

I was wondering if it is possible to import data into a SQL Server 200
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
 
Yes, it's possible to export data from an Excel spreadsheet toward a
SQL-Server database and in fact, there are many ways of doing this. Why
don't you ask in a newsgroup dedicated to Excel? This newsgroup is about
ADP and SQL-Server and has nothing to do with Excel.
 
Back
Top