Re: Exception trying to import data from Excel .

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Hello,

WooHoo. Importing from Excel now functions. If you are in the same
situation, hopefully the following link will be of value to you.

http://tinyurl.com/h49co

Steps that I took.

1- created a plain user account and granted local logon priv
(gpedit.msc)
2 - modified and compiled (csc) the c# program to include a 20 second
delay before exiting (Thread.Sleep(20000);)
3 - copied program to test account folder, opened a cmd window and
executed test program as a low priv user using "runas"
4 - modified the three reported macromedia registry entries to give
read access to "users"
5 - rebooted and installed SQL Server 2005 (still had to ignore that
one message during install)
6 - can now import csv and xls files

Cheers &c.
-Brian


--
SQL Server Newbie

Brian
------------------------------------------------------------------------
SQL Server Newbie's Profile: http://www.dbtalk.net/m167
View this thread: http://www.dbtalk.net/t288815

.