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

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
 
S

Sylvain Lafontaine

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import data into SQL Server from Excel 1
import data from excel command button 2
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
SQL Server 2000 insert primary key in import 1
import data causes "sql server does not exist" 1
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5

Top