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

Hi,

I would be easier if could use Microsoft Access. The Micrsoft Access has the
upsizing tool to Microsoft SQL Server, where you can linked tables.. This way
you can transform data from Excel-Access-SQL Server. The data is cleaned for
accuracy.

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?