Update SQLServer table from Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Greg Stigers, MCSA (gregstigers+wmsn_at_spamcop.net)
Date: 11/10/04


Date: Wed, 10 Nov 2004 18:02:28 -0500

Is it possible to update a SQL Server table from Excel? We have some Mac
users who have Excel, and need to add data to some tables.

-- 
Greg Stigers, MCSA
remember to vote for the answers you like 


Relevant Pages

  • Re: Help with VBA for document formatting.
    ... more easily done with Word instead of Excel so I decided to post this ... My system is a Mac G5 running the latest version of Leopard (not Snow ... number of times corresponding to the size of the alphanumeric code. ... A01.047.025) are indented with two tab keystrokes. ...
    (microsoft.public.mac.office.word)
  • Re: Help with VBA for document formatting.
    ... Python is provided in Mac OS X ... ... more easily done with Word instead of Excel so I decided to post this ... number of times corresponding to the size of the alphanumeric code. ... A01.047.025) are indented with two tab keystrokes. ...
    (microsoft.public.mac.office.word)
  • Re: Help with VBA for document formatting.
    ... more easily done with Word instead of Excel so I decided to post this ... My system is a Mac G5 running the latest version of Leopard (not Snow ... number of times corresponding to the size of the alphanumeric code. ... A01.047.025) are indented with two tab keystrokes. ...
    (microsoft.public.mac.office.word)
  • Re: Mail merge
    ... Phillip Jones wrote: ... Its up to version 9 and works with Intel mac and OSX. ... really isn't any need to move the Excel data into an Access file. ... Although FileMaker is a fine relational database and is a soup-to-nuts solution which can certainly be used in this situation, but it is not needed at all here and would side-step. ...
    (microsoft.public.mac.office.word)
  • Re: fields queries and utter disaster
    ... I suspect that regrettably, in this case the Excel team got to it, the Word ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)