Excel and SQL help
hi,
we have an excel file that gets info from a SQL Server, this is all
fine and works well taking data from two tables on our SQL Server, the
problem is that when a user adds a comment to a cell or enters data
into a field that isnt on SQL server but is used on the excel file,
this information does not stay associated with that particlar record
(although it isnt an actual record on SQL Server because its built from
2 tables) any ideas on how to fix to stop the data from SQL "jumping"
around.
|