Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import data from excel command button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
import data from excel command button
Hi,
I'm not sure this will help. Excel can connect to an SQL server database but that is for bringing data down to Excel. It may be possible to have Excel run an SQL routine at the server which pulls the data into the SQL database. I think you might get some help from the SQL Server Newsgroup under Servers, Server Applications here at Microsoft. A general rule - it is easier to pull data in than to push data out. -- Thanks, Shane Devenshire "Rachel" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
import data from excel command button
Rachel
Yes it is You can either open an ADO recordset on your SQL server using VBA and append the records from Excel Or you can use INSERT INTO and build the SQL string dynamically. Or you could save the files somewhere and use DTS to pull the data in using the JET drivers against the workbooks. You might even be able to do something with the XML. Cheers Simon Excel development website: www.codematic.net Rachel wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is the Data Import Excel button in Excel 2007 | Excel Discussion (Misc queries) | |||
Import Data, using a command line switch | Excel Discussion (Misc queries) | |||
Import Data button | Excel Programming | |||
upload data from an excel worksheet to SQL W/ a command Button | Excel Programming | |||
Import a data using a command button | Excel Programming |