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?
|