Thread: excel - SQL
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default excel - SQL

Hi,

It would easier and comfortable, if you use Microsoft Excel-Access-SQL
Server. The tranformation of data across the Access and SQL is accurate
because of the Upsizing tool availabe in Access. You can have linked table
between Access and SQL Server.

Challa Prabhu

"Johnfli" wrote:

Is it possible to have a worksheet that when a user opens it, the data
displayed is pulled from a table in SQL? Also, if they change something in
that worksheet, it will save the changes in teh SQL table?