April 14, 2008 at 3:49 pm
We want to log data into different Excel files and connect these files to SQL Server 2000 where they will all be saved in the same table. Is there a way for this to be done or will I have to develop an application to do it?
Can i then take the information found in SQL server 2000 and display it like a view in an Excel file?
I'm open to any suggestions. I'm just trying to find some easy and simple solutions.
Basically what will be happening is that User1, 2, 3 will be imputting data into a spreadsheet. Each spreadsheet will save or empty its information into SQL Server. Then they will be able to open a different spreadsheet and view data entered by all three users.
Thanks!
June 24, 2008 at 7:28 pm
The answer is "Yes"... both can be done. Create a view in SQL Server to look at the data you want and then create a spreadsheet to use "External Data". You can even make it automatically refresh once a minute or any time frame you chose.
So far as using the Excel sheet for data entry, make a macro for them that will save the data as a Tab delimited or CSV file and import them using Bulk Insert.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2008 at 11:15 am
For using Excel and SQL Server might I suggest this article which I found to be extremely informative and as a bonus includes sample code
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy