may be work with Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=PWD;Data Source=C:\mydatabase.mdb;Persist Security Info=False
Emimmortal
E
emimmortal
@emimmortal
Posts
-
Connect to a password protected Access database!! -
Import CSV file to MS AccessYou can open the mdb with any .net connection and use the INSERT SQL to import the csv data. Ensure the target table is blank and make a Schema.ini file for define the schema of the csv file. eg. string sql = string.Format("insert into {0} select * from [Text;FMT=Delimited(|);HDR=No;DATABASE={1};].[{2}#csv];", info.TableName, info.FilePath, info.FileName); System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand(sql, connection); command.ExecuteNonQuery(); for schema.ini http://msdn.microsoft.com/en-us/library/ms709353.aspx :)
Emimmortal
-
save excel fileExcel.Application COM may be solve your problem.
Emimmortal
-
Creating setup project for all users of the systemmake a shortcut with msiexec.exe /I Setup.msi ALLUSERS=1 that will install it to all users of the system.
Emimmortal