Package- Update excel - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Package- Update excel

Author

Topic

ellgk
Starting Member

9 Posts

Posted - 2008-10-07 : 05:43:49

hello to everyone

I have created a package that is exporting data from sql to excel file, this procedure will run in a daily base, for that reason i need to updating the data (in excel) and not to add them again.
Is there any method that i can delete the excel and recreate it again? (in a package)
or is there a code that i can write to my package in order to update specific fields with selection criterias?

does anyone knows how to do it?

help! please

thanks
eli

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-07 : 06:09:51

you can update specific fields in excel using OPENROWSET. have a look at books online for details.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-07 : 06:53:33

Examples are here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-07 : 07:03:28

quote:
Originally posted by madhivanan

Examples are here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

ah forgot the famous link. Sorry Madhi

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-07 : 07:06:42

quote:
Originally posted by visakh16

quote:
Originally posted by madhivanan

Examples are here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

ah forgot the famous link. Sorry Madhi

No Problem

Madhivanan

Failing to plan is Planning to fail

ellgk
Starting Member

9 Posts

Posted - 2008-10-09 : 04:48:41

Thanks you to all.
These was very usefully

I have another problem now, after the exporting that i made to excel
i have to protect some columns from the users hence I protect some columns but everytime that im executing the package an error is displayed telling me that i cant update these columns.

what can i do?
any idea?

regards
eli

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-09 : 05:18:01

quote:
Originally posted by ellgk

Thanks you to all.
These was very usefully

I have another problem now, after the exporting that i made to excel
i have to protect some columns from the users hence I protect some columns but everytime that im executing the package an error is displayed telling me that i cant update these columns.

what can i do?
any idea?

regards
eli

if you want to protect it from users why export them at all? export only required columns to excel

ellgk
Starting Member

9 Posts

Posted - 2008-10-09 : 05:49:04

The records are appearing as :

id. decription. id2. value.(input value)

it's nessesary to export all data of the table into excel. The users have to know all these data in order to change the value.

thanks
eli

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-09 : 06:05:18

quote:
Originally posted by ellgk

Thanks you to all.
These was very usefully

I have another problem now, after the exporting that i made to excel
i have to protect some columns from the users hence I protect some columns but everytime that im executing the package an error is displayed telling me that i cant update these columns.

what can i do?
any idea?

regards
eli

what do you mean by protecting the columns?

Madhivanan

Failing to plan is Planning to fail

ellgk
Starting Member

9 Posts

Posted - 2008-10-09 : 08:54:36

there is an option in excel that you can protect your data,to be more specific if you select this option you can't edit the data.
its something like display mode.

i used this selection for 2 colums in my excel file in order to not prohibit users making changes.

thanks
eli

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-10 : 04:58:17

quote:
Originally posted by ellgk

there is an option in excel that you can protect your data,to be more specific if you select this option you can't edit the data.
its something like display mode.

i used this selection for 2 colums in my excel file in order to not prohibit users making changes.

thanks
eli

If the cells are protected then you cant update them

Madhivanan

Failing to plan is Planning to fail

ellgk
Starting Member

9 Posts

Posted - 2008-10-17 : 03:37:35

I cant remove unprotect function only for updating because i want to prohibit users making changes.
Is there any idea how to do this?

thanks
eli

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-17 : 05:22:17

quote:
Originally posted by ellgk

I cant remove unprotect function only for updating because i want to prohibit users making changes.
Is there any idea how to do this?

thanks
eli

Post your question at EXCEL related forums

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources