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

Here is what I am sending our end users. It assumes an existing DSN
definition. Comments and suggestions welcome.
You can run Excel, and open the Workflow.dsn we created in C:\Program
Files\Common Files\ODBC\Data Sources. From the Select Table dialog, choose
an appropriate table. This will return the headers and whatever data there
is, for viewing.
From the Data pull down menu, choose Import External Data > and from its
submenus, choose Edit Query... Choose [Next > ] until you get to the last
dialog. Choose the (o) View Data or edit query in Microsoft Query. Note that
there is also a [Save Query...] button. You can save this query, and later
open this query directly from MS Query. I would recommend naming any saved
queries for their tables.
Once you are in MS Query, with this query loaded, you can from the
Records menu, choose Allow Editing. Once you have done so, you can edit the
table data directly. I would recommend deleting the three test records I
created.
Also, in the future, you should be able to run MS Query directly as
"C:\Program Files\Microsoft Office\Office10\MSQRY32.EXE". From there, you
should be able to open the query directly, and then allow editing.
--
Greg Stigers, MCSA
remember to vote for the answers you like

[quoted text, click to view]

I haven't done that but I have noticed there is a menu item called "Import
External Data" under the Data menu. You need to set up an ODBC connection.

/ Fredrik

hi

you can not directly transfer from xls to sql. ie it will give error since
the filed format will differ. you can do it by using this way.

first create db in ms--access then transfer the data from xls to access by
copy and past then goto sql import option select access db. it will help u.

i have done this excises.

S Kaliyan

[quoted text, click to view]