Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shrews14
Starting Member
37 Posts |
 Posted - 2007-08-30 : 09:38:30
|
| Hias mentioned in title i'm trying to move data from excel into a table in a sql server 2000 database. We have spreadsheets that produce data in excel using querytables. we want a system the other way, by typing data into a spreadsheet, pressing a button which pushes the data into a sql server table. I know this is half VBA and half SPORC question.but i hope you can help!! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-30 : 10:20:46
|
I can, but is will cost you.This request is so far beyond free help.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Shrews14
Starting Member
37 Posts |
Posted - 2007-08-30 : 11:09:48
|
| cheers madhivanan (i think we're heading in the same direction),that helps alot, the only thing i'm not sure of is how you specify the data going in as you have only mentioned a spreadsheet page. I'm fairly confident of of my SProc writing (on a basic level) and of my VBA (again on a basic level).My plan was to have the data in a spreadsheet.VBAConnect to SQL (Done)Put data in to a dataset/querytablePass data in SprocSQL SERVER 2000SPROC takes data and formats/runs certain tasks (i think i can handle this)Updated database!!The issue is how do i pass this data over the connection and how do i get the information out? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-30 : 11:37:27
|
| www.connectionstrings.com to connect VBA and SQL Server and then use a procedure having the Openrowset method and execute that procedure from VBAMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Moving excel data using VBA into SQL server 200