HP3000-L Archives

November 2004, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Excel to SQL Server
From:
Larry Barnes <[log in to unmask]>
Reply To:
Larry Barnes <[log in to unmask]>
Date:
Thu, 11 Nov 2004 06:30:08 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (22 lines) 
I don't know about updating fields via excel but I have written macros
that link to a sql db and extract data and place it in the spreadsheet.
The only problem is you are limited on the number of sql statements you
can enter; only so many characters allowed in the statement. 

-----Original Message-----
From: Greg Stigers [mailto:[log in to unmask]] 
Sent: Wednesday, November 10, 2004 3:11 PM
To: [log in to unmask]
Subject: [HP3000-L] Excel to SQL Server

Can one use Excel as a front-end to SQL Server, and allow a user to
insert / update the data that lives in a SQL Server table?

Greg Stigers

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2